I need to know the duration of a certain state in time series database TDengine, so I tried its stream computing.
My code is as follows:
create stream device_running_s trigger WINDOW_CLOSE watermark 60m into device_running as select devices,wcs_sx_runing,_wstart,_wend,_wduration from point partition by devices state_window(wcs_sx_runing);
It reported an error:
DB error: Unsupported stream
The database version is 3.0.1.4.
The table information:
I read the documentation ,but I didn't find what the problem is.