influxdb: 元数据操作

一、写语法

https://docs.influxdata.com/influxdb/v1.7/write_protocols/line_protocol_tutorial/

二、字段类型

https://docs.influxdata.com/influxdb/v1.7/write_protocols/line_protocol_reference/

获取库下的表列表

SHOW MEASUREMENTS [ON <database_name>] [WITH MEASUREMENT <operator> ['<measurement_name>' | <regular_expression>]] [WHERE <tag_key> <operator> ['<tag_value>' | <regular_expression>]] [LIMIT_clause] [OFFSET_clause]

> SHOW MEASUREMENTS ON NOAA_water_database


name: measurements
name
----
average_temperature
h2o_feet
h2o_pH
h2o_quality
h2o_temperature

三、write API

https://docs.influxdata.com/influxdb/v1.7/guides/writing_data/

四、Querying API

https://docs.influxdata.com/influxdb/v1.7/guides/querying_data/

五、schema查询

• https://docs.influxdata.com/influxdb/v1.7/query_language/schema_exploration/?t=InfluxDB+API#run-a-show-measurements-query-without-the-on-clause
• https://docs.influxdata.com/influxdb/v2.7/query-data/influxql/explore-schema/#run-show-measurements-with-several-clauses-i
• 查询库下的表

curl -G "http://IP:端口/query?db=influxDBDb_20230619160348787&pretty=true" --data-urlencode "q=SHOW MEASUREMENTS" -u 用户名:密码

• 查询字段

curl -G "http://IP:端口/query?db=influxDBDb_20221122205427638&pretty=true" --data-urlencode "q=SHOW FIELD KEYS FROM cpu_load_short11" -u 用户名:密码

• 查询库列表

curl -G "http://IP:端口/query?pretty=true" --data-urlencode "q=SHOW DATABASES" -u 用户名:密码