Example 2: Project from IMDC and Add node_ip and part_id - Aster Execution Engine

SQL-MapReduce Call

This example is like Example 1: Project from IMDC, but it also outputs the IP addresses and partition indexes of the partitions that host the data.

SELECT * FROM project_from_imdc (
  ON nc_system.nc_dummy
  imdc ('data1')
  echo_node_ip ('true')
  echo_part_id ('true')
) ORDER BY a, b;

Projection from IMDC data1