Run CREATE EXTERNAL TABLE

Run CREATE EXTERNAL TABLE

The Hadoop location corresponds to the output path in the MapReduce job.

=# CREATE EXTERNAL TABLE demodata 
   LOCATION ('gphdfs://hdfshost-1:8081/demo/data/MRTest1') 
   FORMAT 'custom' (formatter='gphdfs_import');
Note:

Omit the port number when using the gpmr-1.0-gnet-1.0.0.1 connector.