csv格式数据导入influxdb2.x

一、常见的几种错误

1.1  unable to parse '........': invalid boolean

Error: failed to write data: 400 Bad Request: unable to parse '........': invalid boolean

1.2 类型错误

Error: failed to write data: 422 Unprocessable Entity: failure writing points to database: partial write: field type conflict: input field "signal_strength" on measurement "pos_location" is type float, already exists as type integer dropped=1

Error: failed to write data: 422 Unprocessable Entity: failure writing points to database: partial write: field type conflict: input field "status" on measurement "pos_location" is type float, already exists as type string dropped=1

二、解决方式

1）整数型需要在数值后面加“i”,；

2）字符串前后加双引号“”；

   特别是包含短划线“-”的字符串必须加双引号表示字符串。

   在wps或excel 界面上修改是没有作用的，字符串"00000"如果不加双引号会在导入时自动识别为数值型。

    而整数型如果不加i，会默认识别为float型。