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:
(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 |