In CCL, the Aleri store element migrates to a CREATE MEMORY STORE statement, and the AggregateStream element migrates to an output window. The value of the name attribute in the ColumnExpression element becomes the name of the column in the SELECT clause of the output window.
AleriML:
<Store file="store1" fullsize="64" id="store1" kind="memory"/> <AggregateStream id="Aggrdatatypes" store="store1" istream="alldatatypes"> <ColumnExpression key="true" name="id">alldatatypes.id</ColumnExpression> <ColumnExpression key="false" name="maxA">max(alldatatypes.a)</ColumnExpression> </AggregateStream>
CCL:
CREATE MEMORY STORE store1 PROPERTIES INDEXTYPE ='tree', INDEXSIZEHINT =8; CREATE OUTPUT WINDOW Aggrdatatypes SCHEMA (id INTEGER, maxA LONG) PRIMARY KEY DEDUCED STORE store1 AS SELECT alldatatypes.id AS id, max(alldatatypes.a) AS maxA FROM alldatatypes GROUP BY alldatatypes.id;