...
The following query forwards a processed event as an output to the
cronTriggerStream
event stream every 10 seconds.Code Block language sql define trigger cronTriggerStream at '*/10 * * * * ?' ;
The following query merges the
periodicalTriggerStream
andsensorStream
event streams. Only the values of the attributes specified in the query are merged. Attribute values are taken from thesensorStream
event stream and inserted into theperiodicalTriggerStream
event stream.Code Block language sql from periodicalTriggerStream join sensorStream#window.time(10 sec) select meta_timestamp, meta_isPowerSaverEnabled, meta_sensorId, meta_sensorName, correlation_longitude, correlation_latitude, triggered_time, humidity, sensorValue insert into periodicalTriggeredSensorStream;
The following query merges the
cronTriggerStream
andsensorStream
event streams. Only the values of the attributes specified in the query are merged. Attribute values are taken from thesensorStream
event stream and inserted into thecronTrigerredSensorStream
event stream.Code Block language sql from cronTriggerStream join sensorStream#window.time(10 sec) select meta_timestamp, meta_isPowerSaverEnabled, meta_sensorId, meta_sensorName, correlation_longitude, correlation_latitude, triggered_time, humidity, sensorValue insert into cronTriggeredSensorStream;
Prerequisites
See Prerequisites in the CEP Samples Setup pageSet up the prerequisites required for all samples.
Building the sample
Start the WSO2 CEP server with the sample configuration numbered 0119. For instructions, see Starting sample CEP configurations. This sample configuration does the following:
...
- Log into the CEP Management Console.
Click on the Tools tab and then click Event Simulator to open the Event Stream Simulator page. A file named
events.csv
containing sample data is displayed in the Send multiple events section as follows. Click Play to start sending events to the CEP from this file.
The events triggered in the CEP are logged in your CLI as shown in the extract below.
- The events that are triggered in the
periodicalTriggerStream
event stream every 5 seconds haveperiodical
as the unique ID. - The events that are triggered in the
cronTriggerStream
event stream every 10 seconds havecron
as the unique ID.
- The events that are triggered in the