Example 2: 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

SQL-MapReduce Call

The function call in this query outputs the data in the existing IMDC data6 (created in the example Example 1: IMDC Does Not Exist). The table t1 is replaced at planning time with the empty table NC_SYSTEM.NC_DUMMY (for details, see Optimization When IMDC Exists).

SELECT * FROM imdc_adapter (
  ON t1
  imdc ('data6')
) ORDER BY a, b;

Output

The preceding query returns:
a b
0 0
0 1
1 0
1 1
2 0
2 1
3 0
3 1
4 0
4 1
5 0
5 1
(12 rows)