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');