[gpadmin@zhaogh gpload]$ hostname
zhaogh
[gpadmin@zhaogh gpload]$ gpfdist -d /home/gpadmin/gpload -p 8081 -l /home/gpadmin/test_gpload_log &
[gpadmin@zhaogh gpload]$ cat test.csv
1;a
2;b
3;c
4;d
gp_test_db=# create external table test_ext(id numeric,name varchar) location('gpfdist://zhaogh:8081/test.csv') format 'text' (DELIMITER ';' NULL 'empty');
CREATE EXTERNAL TABLE
gp_test_db=# insert into test select * from test_ext;
INSERT 0 4
转载于:https://blog.51cto.com/bad51men/1314563