Example: SourceStream with insertOnly Attribute Migration

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;