三个设备分别计算每一分钟均值并求和,SQL能否直接实现?

给定一个时间范围,每一分钟一个断面,计算每个设备均值,再对三个设备均值求和。最后返回两列,一列时间,一列三个设备每分钟内均值之和。

请先 登录 后评论

1 个回答

Juntao Wang

示例代码如下:

ids = ["024bafec-0adc-4e51-bffe-793085c0559e", "018b8110-ca1b-4f1e-97b2-0363c8ed49ae", "0164480b-11a8-4312-91e0-c96f9faac95c"]
timePeriod = 2021.01.01T00:00:00.000 : 2021.01.01T00:10:00.000
result = select rowSum(ffill(avg(v))) from loadTable("dfs://GZB_TSDB", "data") where id in ids, time between timePeriod pivot by bar(time, 60000) as minute, id
select sum(rowSum) as v from result group by interval(minute, 1m, "prev") as minute
请先 登录 后评论