Example 1: Fact Table with Default imdcInMemSizeInMB - 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 load_into_imdc function creates an IMDC named data1 as a fact table and loads it with data from Input Table t1. The IMDC occupies the default amount of memory in each partition (10 MB).

SELECT * FROM load_into_imdc (
  ON t1 imdc ('data1')
) ORDER BY PartIdx;

IMDC data1

PartIdx NumRows TotalMemBytes
0 2 16
1 2 16
2 2 16
3 2 16
4 2 16
5 2 16

(6 rows)