| 语法 | CREATE CONTINUOUS QUERY "cq" ON "db" BEGIN SELECT … INTO … FROM … GROUP BY time(…), * END |
|---|---|
| 运行 | 由数据库按时间窗口自动执行；SHOW CONTINUOUS QUERIES 查看 |
| 管理 | ALTER 修改（部分字段）、DROP CONTINUOUS QUERY 删除 |
示例
示例
CREATE CONTINUOUS QUERY "cq_cpu_hourly" ON "metrics"
BEGIN
SELECT mean("usage") AS usage
INTO "metrics"."rp_2y"."cpu_hourly"
FROM "cpu"
GROUP BY time(1h), *
END
SHOW CONTINUOUS QUERIES;CQ 的 GROUP BY time(1h), * 会把全部标签一并聚合进目标测量，维度保持与原始数据一致。