influxdb学习之路——二、数据写入influxdb

一、命令行直接写入单条数据

1、influx client 命令行直接写入数据

root@vms50:~/csv#
root@vms50:~/csv# influx write \
>   -b my-bucket\
>   -o my-org \
>   --configs-path  /mydata/influxdb/config/influx-configs \
>   -p s \
>   'test-measure,env=test aaField="this is aa field without timestamp",bbField=123 ' 
root@vms50:~/csv#

2、influx数据浏览器查看刚写入的数据

浏览器打开： http://192.168.26.50:8086/orgs/2d29121a16927628/data-explorer   

在filter中勾选test-measure相关字段后，submit就可以看到相应的数据了。

二、命令行直接写入多条条数据

1、命令行一次写入多条数据

root@vms50:~/csv#
root@vms50:~/csv# influx write  -b my-bucket -o my-org --configs-path  /mydata/influxdb/config/influx-configs  -p s   \
> 'test-measure,env=app aaField="this is aa field without timestamp",bbField=123 ' \
> 'test-measure,env=hello aaField="hello,this is 147.",bbField=147 ' \
> 'test-measure,env=provid aaField="another value 58",bbField=58 '
root@vms50:~/csv#

2、influx数据浏览器查看刚写入的数据

浏览器打开： http://192.168.26.50:8086/orgs/2d29121a16927628/data-explorer   

在filter中勾选test-measure相关字段后，submit就可以看到相应的数据了。

补充：

======================================================
ok ：四条数据都写成功了

influx write --bucket my-bucket -o my-org --configs-path /mydata/influxdb/config/influx-configs  "  \
m,host=host1 field1=76
m,host=host2 field1=80
m,host=host1 field2=15i
m,host=host2 field2=30i
"


======================================================
ok:可是有env=test的数据写成了

influx write --bucket my-bucket -o my-org --configs-path /mydata/influxdb/config/influx-configs  '  \
test-measure,env=app aaField="tom",bbField=55
test-measure,env=test aaField="Jeff",bbField=66
'
ok:可是有env=test的数据写成了
influx write --bucket my-bucket -o my-org --configs-path /mydata/influxdb/config/influx-configs  '  \
test-measure,env=app aaField="tom",bbField=515 
test-measure,env=test aaField="Jeff",bbField=616 
'
======================================================

ok：两条都写成功了

influx write --bucket my-bucket -o my-org --configs-path /mydata/influxdb/config/influx-configs  "  \
test-measure,env=app bbField=255
test-measure,env=test bbField=266
"

======================================================

三、使用csv数据写入

1、准备csv数据文件

root@vms50:~/csv#
root@vms50:~/csv# cat example1.csv
date,sighted,loc
2020-01-01,12,Boise
2020-06-01,78,Boise
2020-01-01,54,Seattle
2020-06-01,112,Seattle
2020-01-01,9,Detroit
2020-06-01,135,Detroit
root@vms50:~/csv#

2、使用influx write写入influxDB

root@vms50:~/csv# 
root@vms50:~/csv# influx write  -b my-bucket -o my-org  --configs-path /mydata/influxdb/config/influx-configs  -f example1.csv
2021/12/27 18:29:34 line 2: no measurement column found
2021/12/27 18:29:34 line 3: no measurement column found
2021/12/27 18:29:34 Unable to batcher to error-file: invalid argument
2021/12/27 18:29:34 line 4: no measurement column found
2021/12/27 18:29:34 Unable to batcher to error-file: invalid argument
2021/12/27 18:29:34 line 5: no measurement column found
2021/12/27 18:29:34 Unable to batcher to error-file: invalid argument
2021/12/27 18:29:34 line 6: no measurement column found
2021/12/27 18:29:34 Unable to batcher to error-file: invalid argument
2021/12/27 18:29:34 line 7: no measurement column found
2021/12/27 18:29:34 Unable to batcher to error-file: invalid argument
root@vms50:~/csv# 

3、csv文件第一行添加注释

root@vms50:~/csv#
root@vms50:~/csv# cat example1.csv
#datatype measurement,dateTime:RFC3339,string,tag
example1, date,sighted,loc
r1,2021-12-21T00:00:00Z,12,Boise
r1,2021-12-22T15:00:00Z,78,Boise
r1,2021-12-23T12:19:00Z,54,Seattle
r1,2021-12-24T10:10:00Z,112,Seattle
r1,2021-12-25T08:50:00Z,9,Detroit
r1,2021-12-26T05:30:00Z,135,Detroit
root@vms50:~/csv#

4、执行influx write命令

root@vms50:~/csv# 
root@vms50:~/csv# influx write -b my-bucket -o my-org -f example1.csv --configs-path /mydata/influxdb/config/influx-configs
root@vms50:~/csv# 

5、influx数据浏览器查看刚写入的数据

浏览器打开： http://192.168.26.50:8086/orgs/2d29121a16927628/data-explorer   

在filter中勾选r1相关字段后，submit就可以看到相应的数据了。