lf-edge / ekuiper

Lightweight data stream processing engine for IoT edge
https://ekuiper.org
Apache License 2.0
1.48k stars 414 forks source link

Support sequential actions #1973

Open xiaobai0428 opened 1 year ago

xiaobai0428 commented 1 year ago

希望eKuiper在支持并行执行sql的同时 具备串行执行sql的 能力 方便通用化执行

ngjaying commented 1 year ago

@xiaobai0428 Thanks for opening the feature. One question, when running sequentially, what data do you expect for the second SQL action? The same data as the first?

xiaobai0428 commented 1 year ago

Thank you for your reply to execute the first sql in serial and then the second sql is triggered according to the conditions after the first sql is executed. Of course the serial execution can be associated or executed sequentially and there will be a third and a fourth sql to trigger the execution!

ngjaying commented 1 year ago

Thank you for your reply to execute the first sql in serial and then the second sql is triggered according to the conditions after the first sql is executed. Of course the serial execution can be associated or executed sequentially and there will be a third and a fourth sql to trigger the execution!

If the data in sink is like {"temperature":12,"humidity":45}. In the first SQL, it would insert into the table like INSERT INTO weather_data (temperature, humidity) VALUES (12, 45);. Then, what's the data do you expect for the second SQL action?