Example: SourceStream with FilterExpression Migration

In CCL, the Aleri store element migrates to the CREATE MEMORY STORE statement and FilterExpression migrates to a WHERE clause.

Therefore, this example migrates to an input window followed by an output window with a WHERE clause.

AleriML:

<Store file="store1" fullsize="64" id="store1" kind="memory"/>
    <SourceStream id="alldatatypes" store="store1">
    <Column datatype="int32" key="true" name="id"/>
    <Column datatype="int64" key="true" name="a"/>
    <Column datatype="string" key="false" name="charData"/>
    <FilterExpression>alldatatypes.charData in ('aa','bb','cc')</FilterExpression>
  </SourceStream>

CCL:

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