例 1—Greenplum文件服务器(gpfdist)

例 1—Greenplum文件服务器(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);