The Aleri store element migrates to a CREATE MEMORY STORE statement. In CCL, streams are stateless and support only INSERT opcode, and windows are stateful and support all opcodes.
Therefore, this example migrates to an input stream followed by an output window:
AleriML:
<Store file="store1" fullsize="64" id="store1" kind="memory"/> <SourceStream id="alldatatypes" store="store1" insertOnly="true"> <Column datatype="int32" key="true" name="id"/> <Column datatype="int64" key="true" name="a"/> <Column datatype="string" key="false" name="charData"/> </SourceStream>
CCL:
CREATE MEMORY STORE store1 PROPERTIES INDEXTYPE ='tree', INDEXSIZEHINT =8; CREATE INPUT STREAM Ccl_0_alldatatypes SCHEMA (id INTEGER, a LONG, charData STRING); CREATE OUTPUT WINDOW alldatatypes SCHEMA (id INTEGER, a LONG, charData STRING) PRIMARY KEY DEDUCED STORE store1 AS SELECT Ccl_0_alldatatypes.id, Ccl_0_alldatatypes.a, Ccl_0_alldatatypes.charData FROM Ccl_0_alldatatypes GROUP BY Ccl_0_alldatatypes.id, Ccl_0_alldatatypes.a;