The list_imdc function returns a list of IMDCs, by name, in every partition.
Syntax
SELECT * FROM list_imdc (input);
Input
Ignored. Use the empty table NC_SYSTEM.NC_DUMMY (or any other table).
Schema of Output
Column Name | Description |
---|---|
NodeIp | IP address of the node that hosts the data. |
TaskIdx | Task index of the partition that hosts the data. |
Name | Name of the IMDC. |
Example
SQL-MapReduce call:
SELECT * FROM list_imdc (ON NC_SYSTEM.NC_DUMMY);
Output:
NodeIp | TaskIdx | Name |
---|---|---|
10.47.14.44 | 12 | t_1m |
10.47.14.44 | 12 | t_500m |
10.47.14.44 | 12 | t_10m |
10.47.14.44 | 13 | t_1m |
10.47.14.44 | 13 | t_500m |
10.47.14.44 | 13 | t_10m |
10.47.14.44 | 14 | t_1m |
10.47.14.44 | 14 | t_500m |
10.47.14.44 | 14 | t_10m |
10.47.14.44 | 15 | t_1m |
10.47.14.44 | 15 | t_500m |
10.47.14.44 | 15 | t_10m |
10.47.14.44 | 16 | t_1m |
10.47.14.44 | 16 | t_500m |
10.47.14.44 | 16 | t_10m |
10.47.14.44 | 17 | t_1m |
10.47.14.44 | 17 | t_500m |
10.47.14.44 | 17 | t_10m |
10.47.14.43 | 0 | t_1m |
10.47.14.43 | 0 | t_500m |
10.47.14.43 | 0 | t_10m |
10.47.14.43 | 1 | t_1m |
10.47.14.43 | 1 | t_500m |
10.47.14.43 | 1 | t_10m |
10.47.14.43 | 2 | t_1m |
10.47.14.43 | 2 | t_500m |
10.47.14.43 | 2 | t_10m |
10.47.14.43 | 3 | t_1m |
10.47.14.43 | 3 | t_500m |
10.47.14.43 | 3 | t_10m |
10.47.14.43 | 4 | t_1m |
10.47.14.43 | 4 | t_500m |
10.47.14.43 | 4 | t_10m |
10.47.14.43 | 5 | t_1m |
10.47.14.43 | 5 | t_500m |
10.47.14.43 | 5 | t_10m |
10.47.14.42 | 6 | t_1m |
10.47.14.42 | 6 | t_500m |
10.47.14.42 | 6 | t_10m |
10.47.14.42 | 7 | t_1m |
10.47.14.42 | 7 | t_500m |
10.47.14.42 | 7 | t_10m |
10.47.14.42 | 8 | t_1m |
10.47.14.42 | 8 | t_500m |
10.47.14.42 | 8 | t_10m |
10.47.14.42 | 9 | t_1m |
10.47.14.42 | 9 | t_500m |
10.47.14.42 | 9 | t_10m |
10.47.14.42 | 10 | t_1m |
10.47.14.42 | 10 | t_500m |
10.47.14.42 | 10 | t_10m |
10.47.14.42 | 11 | t_1m |
10.47.14.42 | 11 | t_500m |
10.47.14.42 | 11 | t_10m |
(54 rows)