TDengine
TDengine copied to clipboard
Stream processing in 3.x not working as expected
max_current里为什么显示的不是meters里的最大值10.8,反而是最小值10.3?
因为创建流式计算的子查询中有过滤条件 voltage <= 220
create stream current_stream trigger at_once into current_stream_output_stb as select _wstart as wstart, _wend as wend, max(current) as max_current from meters where voltage <= 220 interval (5s);