Page Comparison

from <stream-name> {<conditions>}#window.<window-name>(<parameters>)
insert [<output-type>] into <stream-name> select ( {<attribute-name>} | ‘*’ |)
insert [<output-type>] into <stream-name> 

Window is a limited subset of events from an event stream. Users can define a window and then use the events on the window for calculations. A window has two types of output: current events and expired events. A window emits current events when a new event arrives. Expired events are emitted whenever an existing event has expired from a window.

...

A sliding window that keeps last N events.

From the events having price >= 20 of the StockExchangeStream stream, output the expiring events of the length window to the StockQuote stream. Here the output events will have symbol and the per symbol average price as their attributes, only if the  per symbol average price > 50.

from StockExchangeStream[price >= 20]#window.length(50) 
insert expired-events into StockQuote select symbol, avg(price) as avgPrice
insert expired-events into StockQuote 
group by symbol
 having avgPrice>50

In the above query, avg(prize) is an aggregate function.

...

A sliding window that keeps events arrived within the last T time period.

From the events having symbol == 20 of the StockExchangeStream stream, output the both the newly arriving and expiring events of the time window to the IBMStockQuote stream. Here the output events will have maximum, average and minimum prices that has arrived within last minute as their attributes.

from StockExchangeStream[symbol == 'IBM']#window.time( 1 min ) 
insert all-events into IBMStockQuote select max(price) as maxPrice, avg(price) as avgPrice, min(price) as minPrice
insert all-events into IBMStockQuote 

Time batch window

Anchor
timeBatchWindow timeBatchWindow

A time window that processes events in batches. This in a loop collects the incoming events arrived within last T time period and outputs them as a batch.

From the events of the StockExchangeStream stream, output the events per every 2 minutes from the timeBatch window to the StockQuote stream. Here the output events will have symbol and the per symbol sum of volume for last 2 minutes as their attributes.

from StockExchangeStream#window.timeBatch( 2 min ) 
insert into StockQuote select symbol, sum(volume) as totalVolume
insert into StockQuote 
group by symbol

Length batch window

Anchor
lenghtBatchWindow lenghtBatchWindow

A length window that outputs events as a batch only at the nth event arrival.

From the events having price >= 20 of the StockExchangeStream stream, output the expiring events of the lengthBatch window to the StockQuote stream. Here the output events will have symbol and the per symbol average price> 50 as their attributes.

from StockExchangeStream[price >= 20]#window.lengthBatch(50) 
insert expired-events into StockQuote select symbol, avg(price) as avgPrice
insert expired-events into StockQuote 
group by symbol
having avgPrice>50

...

A  window that keeps only the latest events that are unique according to the given attribute.

From the events of the StockExchangeStream stream, output the expiring events of the unique window to the StockQuote stream. The output events have symbol, price and volume as their attributes.

from StockExchangeStream#window.unique("symbol") 
select symbol, price, volume
insert expired-events into StockQuote symbol, price, volumeStockQuote 

...

A window that keeps the first events that are unique according to the given unique attribute

From the events of the StockExchangeStream stream, output the events of the firstUnique window to the StockQuote stream. The output events have symbol, price and volume as their attributes.

from StockExchangeStream#window.firstUnique("symbol") 
insert into StockQuote select symbol, price, volume
insert into StockQuote 

...