influxdb - influxdb 连续查询将数据移动到保留策略，选择具有许多转换的多个值

Question

您好我正在尝试在 influxDB 1.8 版中进行连续查询。我注意到没有任何文档有效，首先是因为我需要在终端中输入没有返回字符的连续查询（文档显示返回字符可能是为了使其更易于阅读），而且还要放置一个逗号并添加另一个选择语句给我一个解析错误。这是我的命令和解析器错误：

CREATE CONTINUOUS QUERY "old_data_cc" ON "admin" BEGIN SELECT mean("value") as "mean", SELECT min("value") as "min", SELECT max("value") as "max" INTO "old_data" FROM "default" GROUP BY time(1h) END

ERR：错误解析查询：在第 1 行找到 SELECT、预期标识符、字符串、数字、布尔值、字符 84

标签： influxdbretention

Answer 1

SELECT不需要多个s。尝试：

CREATE CONTINUOUS QUERY "old_data_cc" ON "admin" BEGIN SELECT mean("value") as "mean", min("value") as "min", max("value") as "max" INTO "old_data" FROM "default" GROUP BY time(1h) END