taosdata/TDengine

Interval over DIFF nested query

Open

#22,240 创建于 2023年7月28日

在 GitHub 查看
 (1 评论) (0 反应) (1 负责人)C (5,002 fork)batch import
help wantedquestion

仓库指标

Star
 (24,849 star)
PR 合并指标
 (平均合并 1天 1小时) (30 天内合并 4 个 PR)

描述

I have a query 
 select count() as counter from (select ts, DIFF(variable_value_float) as st_count from table_name where system_uuid = '' and variable_name = '' and ts >= now - 5d and ts <= now - 3d) where st_count = 1 
 But when I want to apply an interval at the end as in example below:
 select count() as counter from (select ts, DIFF(variable_value_float) as st_count from table_name where system_uuid = '' and variable_name = '' and ts >= now - 5d and ts <= now - 3d) where st_count = 1 interval(1d)
 I have an error Window query not supported, since the result of subquery not include valid timestamp column.
 Any suggestions?

Also it will be appreciated if you could answer, how I could make a query over multiple variable_name and group by it.

贡献者指南