Run CREATE EXTERNAL TABLE
This version of the Pivotal Greenplum documentation is no longer actively maintained. Click here to view the most up-to-date version of the Greenplum 4.x documentation.
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');