project_from_imdc - Aster Execution Engine

The project_from_imdc function projects (outputs) data from a specified, existing IMDC. Optionally, the function also outputs the IP addresses and partition indexes of the partitions that host the data.

Syntax

SELECT * FROM project_from_imdc (
  input
  imdc (imdc_name)
  [ echo_node_ip ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
  [ echo_part_ip ({'true'|'t'|'yes'|'y'|'1'|'false'|'f'|'no'|'n'|'0'}) ]
);

Input

Ignored. Use the empty table NC_SYSTEM.NC_DUMMY (or any other table).

Arguments

imdc

Specifies the name of the IMDC out of which data is to be projected. If the specified IMDC does not exist, the function throws the exception InMemoryDataCollectionDoesNotExistException.

echo_node_ip

Specifies whether to output the IP address of the node that hosts the data. Default: 'false'.

echo_part_ip

Specifies whether to output the partition index of the partition that hosts the data. Default: 'false'.

Schema of Output