SQL-MapReduce Call
The function call in this query projects data from the IMDC named data1, created in load_into_imdc Example 1: Fact Table with Default imdcInMemSizeInMB.
SELECT * FROM project_from_imdc ( ON nc_system.nc_dummy imdc ('data1') ) ORDER BY a, b;
Projection from IMDC data1
The preceding query returns:
(12 rows)
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 |