Example 1 - WarehousePG file server (gpfdist) v6.27.4
This section is adapted from the WarehousePG v6.x documentation
=# 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