influxdb遇到的问题

2020-11-05  本文已影响0人  潘雪雯

error parsing query: GROUP BY requires at least one aggregate function
因为加了GROUP BY time(1m),可能同时有多个点,必须要有聚合函数汇聚成一个点,才能进行下一步。所以如果按时间聚合的话,必须要有聚合函数例如sum()之类的函数

SELECT sum("a" + "b" AS "c" FROM "tofino_bvr_vrouter_table" WHERE("A" =~ /^$A$/ )  AND $timeFilter GROUP BY time(1m),  "A"
上一篇 下一篇

猜你喜欢

热点阅读