Example: FilterStream with Stateful Store Migration

In CCL, the Aleri store element migrates to a CREATE MEMORY STORE statement, and the Aleri FilterStream element migrates to an output window.

AleriML:

<Store file="store1" fullsize="64" id="store1" kind="memory"/>
<FilterStream id="filterdatatypes" store="store1" istream="alldatatypes">
 <FilterExpression>alldatatypes.charData in ('aa','bb','cc')</FilterExpression>
</FilterStream>

CCL:

CREATE  MEMORY  STORE store1 PROPERTIES  INDEXTYPE ='tree',  INDEXSIZEHINT =8;
CREATE  OUTPUT  WINDOW filterdatatypes
SCHEMA (id INTEGER, a LONG, charData STRING)
PRIMARY KEY (id, a)
 STORE store1
 AS 
SELECT  * FROM alldatatypes
WHERE alldatatypes.charData in ('aa','bb','cc');