使用‘时间维度聚合’查询时,返回的ts的含义是什么? #4630
Luokun2016
started this conversation in
General
Replies: 1 comment
-
因为用了 interval ,结果返回的 ts 是时间窗口的起始时间 |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
使用
时间维度聚合
查询时,返回的时间点含义是什么?如下图,数据库中的数据从
2020-12-18 07:57:01.000
才有数据,时间维度聚合后时间就从
2020-12-18 07:55:00.000
开始的select * from fcloudqa.tb4556512529240555520 where ts > '2020-12-18 00:00:00' and ts < '2020-12-18 23:59:59'
select avg(val) from fcloudqa.tb4556512529240555520 where ts > '2020-12-18 00:00:00' and ts < '2020-12-18 23:59:59' interval(5m)
Beta Was this translation helpful? Give feedback.
All reactions