[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