In CCL, the Aleri store element migrates to a CREATE MEMORY STORE statement and the ComputeStream 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, and the value of the ColumnExpression element becomes the value in the SELECT clause.
AleriML:
<Store file="store1" fullsize="64" id="store1" kind="memory"/> <ComputeStream id="Normalizeddatatypes" store="store1" istream="alldatatypes"> <ColumnExpression key="true" name="id1" >alldatatypes.id</ColumnExpression> <ColumnExpression name="a1">alldatatypes.a * 5</ColumnExpression> <ColumnExpression name="charData1">alldatatypes.charData</ColumnExpression> </ComputeStream>
CCL:
CREATE MEMORY STORE store1 PROPERTIES INDEXTYPE ='tree', INDEXSIZEHINT =8; CREATE OUTPUT WINDOW Normalizeddatatypes SCHEMA (id 1 INTEGER, a1 LONG, charData1 STRING) PRIMARY KEY (id) STORE store1 AS SELECT alldatatypes.id AS id1, alldatatypes.a * 5 AS a1, alldatatypes.charData AS charData1 FROM alldatatypes;