本文共 630 字,大约阅读时间需要 2 分钟。
目录
nfluxdb提供了一些内置函数,这些函数方便grafana拉取数据。
函数 | 介绍 |
查询非空值的数量 |
SELECT COUNT(field) FROM measurement |
查询唯一值 | SELECT DISTINCT(field) FROM measurement |
查询平均值 | SELECT SUM(field) FROM measurement |
查询最大的N个值 | SELECT TOP(field,N ) FROM measurement |
查询最小的N个值 | SELECT BOTTOM(field, N) FROM measurement |
SELECT COUNT(value) FROM cpuinfo
insert cpuinfo,item=shijiange_47.105.99.75_cpu.idle value666=90
SELECT COUNT(value) FROM cpuinfo
SELECT DISTINCT(value) FROM cpuinfo
SELECT MEAN(value) FROM cpuinfo
SELECT SUM(value) FROM cpuinfo
SELECT TOP(value, 3) FROM cpuinfo
SELECT BOTTOM(value, 3) FROM cpuinfo
转载地址:http://nattf.baihongyu.com/