SQL-MapReduce Call
The load_into_imdc function creates an IMDC named data3 as a fact table and loads it with data from Input Table t1. The IMDC occupies the specified amount of memory in each partition (20 MB).
SELECT * FROM load_into_imdc ( ON t1 imdc ('data3') imdcInMemSizeInMB ('20') ) ORDER BY PartIdx;
IMDC data3
PartIdx | NumRows | TotalMemBytes |
---|---|---|
0 | 2 | 16 |
1 | 2 | 16 |
2 | 2 | 16 |
3 | 2 | 16 |
4 | 2 | 16 |
5 | 2 | 16 |
(6 rows)