Example 2: Dimension Table with Default imdcInMemSizeInMB - Aster Execution Engine

SQL-MapReduce Call

The load_into_imdc function creates an IMDC named data2 as a dimension table and loads it with data from Input Table t1. The IMDC occupies the default amount of memory in each partition (10 MB). The function loads the entire table into each partition.

SELECT * FROM load_into_imdc (
  ON t1 PARTITION BY ANY
  ON t1 AS d1 DIMENSION
  imdc ('data2')
) ORDER BY PartIdx;

IMDC data2

(6 rows)