Line Protocol

/query
/write

db  指定数据库
q   指定查询语句
pretty  true/false


多查询语句 ;分隔
时间格式 默认 rfc3339 ，epoch=[h,m,s,ms,u,ns]设置格式

响应状态码
2xx  204写入成功
4xx  客户端错误
5xx  服务端错误




curl -i -XPOST http://localhost:8086/query --data-urlencode "q=CREATE DATABASE mydb"
curl -i -XPOST http://localhost:8086/query --data-urlencode "q=SHOW DATABASES"
curl -i -XPOST http://localhost:8086/query?pretty=true --data-urlencode "q=SHOW DATABASES"

curl -i -XPOST http://localhost:8086/query?pretty=true --data-urlencode "db=mydb1" --data-urlencode "q=select * from mytable1"

curl -i -XPOST http://localhost:8086/query?pretty=true --data-urlencode "db=mydb1" --data-urlencode "epoch=h"   --data-urlencode "q=select * from mytable1"


curl -i -XPOST http://localhost:8086/query  "q=SHOW DATABASES"

-i 显示响应头



写入数据
curl -i -XPOST 'http://localhost:8086/write?db=mydb1' --data-binary 'mytable2,host=dyyx load1=4.61,load5=3.52,load15=3.47'

curl -i -XPOST http://localhost:8086/query?pretty=true --data-urlencode "db=mydb1" --data-urlencode "q=select * from mytable2"

1601770449528928000
1601770450000000000
1601770451000000000
批量 指定时间戳
curl -i -XPOST 'http://localhost:8086/write?db=mydb1' --data-binary 'mytable2,host=dyyx load1=3.62,load5=3.51,load15=3.46 1601770450000000000
mytable2,host=dyyx load1=3.32,load5=3.50,load15=3.44 1601770451000000000'

指定数据文件
data.txt
mytable3,host=dyyx load1=4.61,load5=3.52,load15=3.47 1601770450000000000
mytable3,host=dyyx load1=3.62,load5=3.51,load15=3.46 1601770451000000000
mytable3,host=dyyx load1=3.32,load5=3.50,load15=3.44 1601770452000000000

curl -i -XPOST 'http://localhost:8086/write?db=mydb1' --data-binary @data.txt

多个查询语句
curl -i -XPOST http://localhost:8086/query?pretty=true --data-urlencode "db=mydb1" --data-urlencode "q=select * from mytable2;select * from mytable3"




 curl实用技巧