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
Column Name | Description |
---|---|
NodeIp | IP address of the node that hosts the data. |
PartIdx | Partition index of the partition that hosts the data. |
imdc_column | IMDC column specified in the SELECT list. Every specified IMDC column appears in the output. |