时序库INFLUXDB 查询时 SHOW MEASUREMENTS ON <database_name> 有数据 但是 SHOW * from MEASUREMENTS 没数据？

Question

时序库INFLUXDB 查询时 SHOW MEASUREMENTS ON <database_name> 有数据 但是 SHOW * from MEASUREMENTS 没数据

Answer 1

没有这样的语法
如果去执行，会直接报错。

show * from [your measurements];
ERR: error parsing query: found *, expected CONTINUOUS, DATABASES, DIAGNOSTICS, FIELD, GRANTS, MEASUREMENT, MEASUREMENTS, QUERIES, RETENTION, SERIES, SHARD, SHARDS, STATS, SUBSCRIPTIONS, TAG, USERS at line 1, char 6

按照提示你可以这样写

show field keys from [your measurements];