Skip to content

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);