Example 1—WarehousePG file server (gpfdist) v7.4

Suggest edits
=# 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);

Parent topic: Defining a File-Based Writable External Table

← Prev

Defining a File-Based Writable External Table

↑ Up

Defining a File-Based Writable External Table

Next →

Example 2—Hadoop file server (pxf)