Open wild-River2016 opened 3 weeks ago
使用滑动窗口(SLIDINGWINDOW)创建温度持续30秒大于75度的规则,没有结果输出。 规则: select temp from stream1 group by SLIDINGWINDOW(ss,30,30) over (when temp > 75) having min(temp) > 75 测试数据: {"deviceId":100,"temp":70.1} {"deviceId":100,"temp":76.1} {"deviceId":100,"temp":77.1} {"deviceId":100,"temp":79.1} {"deviceId":100,"temp":79.1} {"deviceId":100,"temp":79.1} {"deviceId":100,"temp":80.1}
select temp from stream1 group by SLIDINGWINDOW(ss,30,30) over (when temp > 75) having min(temp) > 75
Environment:
2.0.0
What happened and what you expected to happen: 麻烦看一下配置规则是否正确,如何才能输出结果。 期望能得到案例集锦中(总电流持续10s超过200A)的效果。
Having min(temp) > 75 is false. Additionally, SLIDINGWINDOW(ss,30,30) over (when temp > 75) will trigger after 30 seconds. Use SLIDINGWINDOW(ss,30) over (when temp > 75) may be what you want.
使用滑动窗口(SLIDINGWINDOW)创建温度持续30秒大于75度的规则,没有结果输出。 规则:
select temp from stream1 group by SLIDINGWINDOW(ss,30,30) over (when temp > 75) having min(temp) > 75
测试数据: {"deviceId":100,"temp":70.1} {"deviceId":100,"temp":76.1} {"deviceId":100,"temp":77.1} {"deviceId":100,"temp":79.1} {"deviceId":100,"temp":79.1} {"deviceId":100,"temp":79.1} {"deviceId":100,"temp":80.1}Environment:
2.0.0
):What happened and what you expected to happen: 麻烦看一下配置规则是否正确,如何才能输出结果。 期望能得到案例集锦中(总电流持续10s超过200A)的效果。