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 |
|
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 |
|
Concatenate two same-structure composite tables |
|
Open a composite table |
|
Generate a composite table’s base table from a file |
|
Generate a cluster composite table’s base table from a cluster file |
|
Copy a composite table file to another composite table file |
|
Restore a composite table file to the previous state when update error happens |
|
Generate a cluster file from a remote composite table file |
|
Ø joinx() |
Join multiple synchronously segmented cluster cursors/multicursors |
Ø k{} |
Get certain bytes from a serial byte to form a single-byte serial byte |
Ø k1+k2 |
Concatenate serial bytes |
Find one or more records from a memory table according to specified key value(s) |
|
Ø memory() |
Generate a cluster memory table from a local memory table |
Append records in a cursor/distributed cursor to an attached entity 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 |
Perform grouping and aggregation over a pre-summarized data cube |
|
Close a composite table file |
|
Store the result set of grouping an entity table as a pre-summarized data cube |
|
Segment an entity 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 |
|
Segment a memory table/cluster memory table and return cursor of the specified segment |
|
Divide a memory table in sync with a memory multicursor and return it also as a memory multicursor |
|
Delete specified record(s) from an entity table |
|
Delete specified record(s) from a memory table |
|
Delete specified records from a cluster 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 |
|
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 |
|
Create an index file for an entity table |
|
Create an index for the key of a memory table |
|
Ø T.keys() |
Define the key(s) for a memory table |
Ø T.len() |
Get the number of records in a memory table |
Convert a compressed memory table into an uncompressed one |
|
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 non-key fields from a cluster composite table according to key values of a table sequence/record sequence or a cursor and return a table sequence or a cluster multcursor |
|
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 |
|
Open a composite table file or a homo-name files group using the password |
|
Use password to open a cluster file. |
|
Modify a field name or the index name |
|
Update records in an entity table |
|
Update records in a memory table |
|
Update records in a cluster composite table |
|
Return an attached table’s records as a sub table sequence |