The INSERT INTO clause can be used when making SELECT statement results usable as an event stream, when inserting into a named window, and when merging multiple event streams.
Syntax:
insert into eventStreamName [ ( propertyName [,propertyName] [, ...] ) ]
At eventStreamName, specify the identifier used as the name of the event stream that outputs results. This can also be the event type names in the event stream. This eventStreamName can also be used when describing processing in other complex event processing statements. propertyName can also be specified at the same time as an eventStreamName.
The results of a SELECT statement can be inserted in a named window by specifying the name of a named window in an eventStreamName.
Streams can be merged by specifying an existing event stream name in an eventStreamName.
Note
Notes on using Virtual Data Windows
A Terracotta cache holds only one event (cache entry) for the value of a key property. Therefore, if a new event is inserted into a Virtual Data Window using an INSERT INTO clause and the cache already contains an event that has the same key property value, the event is updated using the new event.
