Example 1: IMDC Exists - 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

Input: IMDC 'sample'

PartIdx NumRows TotalMemBytes
1 14831 367067
0 14832 367092

SQL-MapReduce Call

SELECT * FROM get_imdc_meta_info (
  ON NC_SYSTEM.NC_DUMMY
  imdc ('sample')
);

Output

Columns 1-5
NodeIp TaskIdx Name RowCount BlockCount
10.80.165.82 1 sample 14831 75
10.80.165.82 1 sample 14831 75
10.80.165.82 1 sample 14831 75
10.80.165.82 1 sample 14831 75
10.80.165.82 1 sample 14831 75
10.80.165.82 1 sample 14831 75
10.80.165.82 0 sample 14831 75
10.80.165.82 0 sample 14831 75
10.80.165.82 0 sample 14831 75
10.80.165.82 0 sample 14831 75
10.80.165.82 0 sample 14831 75
10.80.165.82 0 sample 14831 75
Columns 6-10
TotalMemBytes MaxInMemBytes ColName ColType ColMemBytes
367067 2147483648 id integer 62400
367067 2147483648 point1 integer 62400
367067 2147483648 point2 integer 62400
367067 2147483648 point3 integer 62400
367067 2147483648 point4 integer 62400
367067 2147483648 point5 integer 62400
367067 2147483648 id integer 62400
367067 2147483648 point1 integer 62400
367067 2147483648 point2 integer 62400
367067 2147483648 point3 integer 62400
367067 2147483648 point4 integer 62400
367067 2147483648 point5 integer 62400

(12 rows)