T.memory( C,…;w )

Description:

Generate a cluster in-memory table from a cluster entity table.

Syntax:

T.memory(C,…;w)

Note:

The function generates a cluster in-memory table, which inherits the zone table expression, from a cluster entity table T, which must have at least one dimension that is used to segment T and facilitates the segmentation. Clear a node’s memory at exit; will perform auto-clear when timeout occurs.

Parameters:

C

A column name; import all columns when the parameter is omitted

w

Filtering condition; won’t perform filtering when the parameter is omitted

T

A cluster composite table’s entity table with dimensions

Options:

@v

Use column-wise memory access

@z

Generate an in-memory table of a compressed format; the option should work with @v option

Return value:

  A cluster in-memory table object

Example:

 

A

 

1

=file("emp1.ctx",["192.168.0.116:8281","192.168.0.129:8281"])

Open a cluster file

2

=A1.open()

Generate a cluster table

3

=A2.attach(t1)

Get cluster table t1

4

=A3.memory(NAME,GENDER;EID<5)

Get columns NAME and GENDER with EID being less than 5 from t1 to generate an in-memory table

 

 

A

 

1

=file("STUDENTS.ctx":[1,2],["192.168.31.165:8281","192.168.31.39:8281"])

Open a cluster file

2

=A1.open()

Generate a cluster composite table

3

=A2.memory@vz()

Generate a cluster in-memory table of compressed format