Example 1—Greenplum file server (gpfdist)

A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.

Example 1—Greenplum file server (gpfdist)

=# CREATE WRITABLE EXTERNAL TABLE unload_expenses 
   ( LIKE expenses ) 
   LOCATION ('gpfdist://etlhost-1:8081/expenses1.out', 
             'gpfdist://etlhost-2:8081/expenses2.out')
 FORMAT 'TEXT' (DELIMITER ',')
 DISTRIBUTED BY (exp_id);