list_imdc - Aster Execution Engine

Teradata Aster® Developer Guide

Product
Aster Execution Engine
Release Number
7.00.02
Published
July 2017
Language
English (United States)
Last Update
2018-04-13
dita:mapPath
xnl1494366523182.ditamap
dita:ditavalPath
Generic_no_ie_no_tempfilter.ditaval
dita:id
ffu1489104705746
lifecycle
previous
Product Category
Software

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)