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

Parent topic: Defining a File-Based Writable External Table