SQL-MapReduce Call
The function call in this query creates an IMDC named data6 and populates it with data from Input Table t1.
SELECT * FROM imdc_adapter (
ON t1
imdc ('data6')
) ORDER BY a, b;
IMDC data6
| 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 |
(12 rows)