Composite-Table-Related Functions

The following are composite-table-related functions that handle computations over composite tables that are unique in esProc.

Ø  $(d)dql...

Execute DQL query statement

Ø  C

A column in a table, its parent table, or a table above them

Ø  cs.joinx()

Join up a cursor and an entity table by the foreign key

Ø  cs.memory()

Generate an in-memory table from a cursor

Ø  cs.pjoin()

Create association between cursors or record sequences through the join key

Ø  CS.merge()

Merge a sequence of composite table cursors

Ø  d.query(dql,...)

Execute DQL query statement

Ø  dql(meta)

Create DQL connection

Ø  f.create(C,…;x;b)

Generate a composite table’s base table from a file

Ø  file(fn:z)

Return a file or homo-name files group preceded by corresponding zone table number(s)

Ø  f.open()

Open a composite table’s base table

Ø  f.reset()

Reorganize a composite table file/homo-name files group and write it to a new composite table file/homo-name files group

Ø  f.rollback()

Restore a composite table file to the previous state when update error happens

Ø  f.structure()

Get structure information of a composite table/ multizone composite table /index file/preaggregation file

Ø  k.r(T,F)

Query a specified field in a specific row in an in-memory table

Ø  k.row

Find one or more records from an in-memory table according to specified key value(s)

Ø  k.sbs()

Get an integer consisting of certain bytes of a serial byte key

Ø  movefile()

Copy, move, delete or rename a file

Ø  pseudo(pd,n)

Generate a pseudo table definition object

Ø  T.alter(F:x,…;F’,…)

Alter one or more fields in an entity table

Ø  T.append(cs)

Append records in a cursor to an entity table

Ø  T.append(cs)

Append-write records of a cursor to a pseudo table

Ø  T.attach(T’)

Open a composite table’s attached table

Ø  T.attach(T’,C)

Add an attached table to a composite table’s base table

Ø  T.C

Retrieve a specified column from an attached table

Ø  T.cgroups(Fi,…;y:Gi,…;w;f,…)

Perform grouping & aggregation using the  composite table/multizone composite table’s preaggregation file

Ø  T.close()

Close a composite table file

Ø  T.close()

Close a pseudo table

Ø  T.conj(…)

Define a computation on a pseudo table, which splits each of its records and concatenates the result records

Ø  T.create(f:b;x)

Create a new composite table file using the data structure of an existing composite table

Ø  T.cuboid(f,Fi,…;y,)

Generate preaggregation file for a composite table/multizone composite table

Ø  T.cursor(x:C,;wi,...;k:n)

Segment an entity/in-memory table/multizone composite table and return the cursor of a specified segment

Ø  T.cursor(x:C,...;wi,...;mcs)

Synchronously segment an entity table/in-memory table/multizone composite table according to a multicursor and return a multicursor

Ø  T.cursor(xi:Ci,…)

Get a cursor based on a pseudo table

Ø  T.derive(xi :Fi,…)

Define the computation of adding fields to a pseudo table and return a new pseudo table

Ø  T.f(C)

Perform an aggregate operation over an attached table’s column

Ø  T.find(k,…)

Find the record(s) according to the specified primary key value(s) from an in-memory table

Ø  T.find(k;x:C,...)

Get record(s) in an entity table or a multizone composite table according to key value(s)

Ø  T.fjoin(w:Ti,x:F,…;…)

Define a foreign-key-style association on a pseudo table and return a new pseudo table

Ø  T.group(xi,…)

Define a computation, which will group records by comparing the grouping field in each with its next neighbor, on a pseudo table and return a new pseudo table

Ø  T.group(x:F,...;y:G,…)

Define a computation, which will group records by comparing the grouping field in each with its next neighbor and perform aggregation over each group, on a pseudo table and return a new pseudo table

Ø  T.groups(x:F,…;y:G…;n)

Group records in a pseudo table

Ø  T.groupn(x;F)

Define a computation on a pseudo table, which will group its records and write the grouped subsets to a sequence of bin files

Ø  T.icursor(C,;w;f,…)

Use index to query data in an entity table

Ø  T.ifind(k,...;I)

Search for a specified key value in an in-memory table according to the index.

Ø  T.import()

Read in records from an entity table and return them as a table sequence

Ø  T.import(xi:Ci,…)

Get a table sequence based on a pseudo table

Ø  T.index(f:h,w;C,…;F,…)

Create an index file for an entity table

Ø  T.index(I:h,w;C,…)

Create one or multiple non-primary-key-based indexes for an in-memory table

Ø  T.index(n)

Create an index for the key of an in-memory table

Ø  T.join(C:.,A:K,x:F,…; …;…)

Define a computation of foreign-key-style join on a pseudo table and return a new pseudo table

Ø  T.keys()

Define the key(s) for an in-memory table

Ø  T.keys@i(Ki,;n) 

Set primary key for an in-memory table and in the meantime create index on it

Ø  T.len()

Get the number of records in an in-memory table

Ø  T.memory()

Convert a table sequence to an in-memory table

Ø  T.memory(C,…;w)

Generate an in-memory table from an entity table

Ø  T.new(A/cs:K…,x:C,...;wi)

Return a table sequence/cursor consisting of the specified fields according to the correspondence between the composite table’s key (/dimension) and the corresponding field in the table sequence/cursor

Ø  T.news(A/cs:K…,x:C,...;wi)

Return a table sequence/cursor consisting of the specified fields according to the correspondence between the table sequence/cursor’s key and the corresponding field in the composite table

Ø  T.pjoin()

Define an association computation between a pseudo table and a cursor/record sequence through the join key on a pseudo table

Ø  T.pseudo(T’,…)

Segment a pseudo table according to the segmentation way of another

Ø  T.rename(F:F’,…)

Rename fields in an entity table or distributed table

Ø  T.run (xi:Fi,…)

Define value assignment operation on a pseudo table and return a new pseudo table

Ø  T.select(x)

Define a record filtering operation on a pseudo table and return a new pseudo table

Ø  T.select(x;f)

Define a record filtering operation on a pseudo table, return a new pseudo table, and write ineligible records to a bin file

Ø  T.switch(Fi,Ai:x;…)

Define a field value switching operation on a pseudo table and return a new pseudo table

Ø  T.update(P:D)

Update records in an entity table

Ø  T.update(P:D)

Update records in a pseudo table

Ø  T{x:C,...}

Return an attached table’s records as a sub table sequence