The following are composite-table-related functions that handle computations over composite tables that are unique in esProc.
A column in a table, its parent table, or a table above them |
|
Create a cluster channel and push data in a specified cluster cursor into it |
|
Create a cluster channel and push data in another cluster channel into it |
|
Fetch data from a distributed cursor |
|
Group a cluster cursor by comparing each record with its next neighbor |
|
Group a cluster cursor by comparing each record with its next neighbor and then aggregate each group |
|
Group the records in a cluster cursor |
|
Group records in a cluster cursor and return result as a synchronously segmented cluster cursor |
|
A foreign-key-style join between a cluster cursor and a record sequence |
|
Join up a cursor and an entity table by the foreign key |
|
Generate a memory table from a cursor |
|
Generate a cluster memory table from a cluster cursor |
|
Merge all parts of a composite table multicursor into an ordinary cursor |
|
Merge a sequence of composite table cursors |
|
Sort data in a cluster cursor |
|
Replace values of a specified field in a cluster cursor with the referencing field values of the corresponding record in another table |
|
Generate a composite table’s base table from a file |
|
Return a file or homo-name files group preceded by corresponding zone table number(s) |
|
Generate a new cluster homo-name files group using the distribution style of an existing one |
|
Generate a cluster file on one or more nodes |
|
Reorganize a composite table file and write it to another composite table file |
|
Restore a composite table file to the previous state when update error happens |
|
Ø joinx() |
Join multiple synchronously segmented cluster cursors/multicursors |
Join up multiple pseudo tables |
|
Ø k1+k2 |
Concatenate serial bytes |
Ø k.r(T,F) |
Query a specified field in a specific row in an in-memory table |
Find one or more records from a memory table according to specified key value(s) |
|
Ø k.sbs() |
Get an integer consisting of certain bytes of a serial byte key |
Ø memory() |
Generate a cluster memory table from a local memory table |
Move a specified file in a node to another node |
|
Generate a pseudo table definition object |
|
Synchronize a local path onto a sequence of nodes |
|
Alter one or more fields in an entity table |
|
Append records in a cursor to an entity table |
|
Append-write records of a cursor to a pseudo table |
|
Retrieve an attached table from a cluster composite table |
|
Add an attached table to a composite table’s base table |
|
Ø T.C |
Retrieve a specified column from an attached table |
Close a composite table file |
|
Close a cluster table |
|
Create a new composite table file using the data structure of an existing composite table |
|
Store the result set of grouping an entity table/multi-zone composite table as a pre-summarized data cube |
|
Segment an entity/in-memory table and return the cursor of a specified segment |
|
Return one or more specified columns of a cluster entity table/cluster memory table as a cluster cursor |
|
Synchronously segment an entity table according to a multicursor and return a multicursor |
|
Synchronously segment a cluster entity table according to a cluster multicursor and return a cluster multicursor |
|
Get a cursor based on a pseudo table |
|
Delete specified record(s) from an entity table |
|
Delete one or more specified records from a pseudo table |
|
Add fields of a composite table to a table sequence/cursor according to the latter's key values |
|
Add fields of a cluster composite table to a table sequence/cursor according to the latter's key values |
|
Ø T.dup() |
Join up cluster memory table into a local memory table |
Ø T.dup(h) |
Copy a local memory table onto nodes to create a duplicate cluster memory table |
Ø T.f(C) |
Perform an aggregate operation over an attached table’s column |
Find the record(s) according to the specified primary key value(s) from a memory table |
|
Find the record(s) according to the specified primary key value(s) from the base table |
|
Group records of a pseudo table by comparing the grouping field in each with its next neighbor |
|
Group records in a pseudo table |
|
Use index to filter an entity table according to the filtering condition |
|
Use index to filter a cluster table according to the filtering condition |
|
Read in records from an entity table and return them as a sequence, record sequence or table sequence |
|
Get a table sequence based on a pseudo table |
|
Create an index file for an entity table/multi-zone composite table |
|
Create an index for the key of a memory table |
|
The foreign-key style join between an in-memory table and a table sequence or two in-memory tables |
|
Ø T.keys() |
Define the key(s) for a memory table |
Ø T.len() |
Get the number of records in a memory table |
Generate a memory table from an entity table |
|
Generate a cluster memory table from a cluster entity table |
|
Get values of specified field(s) according to key values in a table sequence, record sequence or a cursor and return result as a table sequence or a cursor |
|
Retrieve specific fields from a cluster composite table according to key values of a table sequence/record sequence or a cursor and return a cluster multicursor |
|
Get values of specified field(s) according to key values in a table sequence or a cursor, concatenate them and return result as a table sequence or a cursor |
|
Get values of specified field(s) according to key values in a cluster in-memory table or a cluster cursor, and concatenate them into a new table sequence or a cluster multicursor |
|
Replace values of specified fields in an in-memory table with the corresponding referencing field values |
|
Ø f.open() |
Open a composite table’s base table |
Ø f.open() |
Generate a cluster table from a cluster file |
Rename fields in an entity table or distributed table |
|
Select records from a pseudo table according to a specified condition and return the original pseudo table |
|
Update records in an entity table |
|
Update records in a pseudo table |
|
Return an attached table’s records as a sub table sequence |