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"