| 基本结构 | SELECT func("field") FROM "measurement" WHERE time > now() - 1h GROUP BY time(5m), "tag" |
|---|---|
| 常用函数 | mean、sum、max、min、count、percentile、derivative、non_negative_derivative |
| 补值 | fill(null|0|previous|linear);时间边界可用 tz('Asia/Shanghai') |
示例
示例
SELECT mean("usage") AS cpu
FROM "cpu"
WHERE time > now() - 6h AND "host" = 'web-1'
GROUP BY time(5m), "region"
fill(null)
tz('Asia/Shanghai');2.x 集群默认保留 v1 兼容查询接口,但数据模型映射与 1.x 有差异,迁移前对照官方兼容说明验证。