반응형
/****************************************************************************************************************
-- Title : [PGS9.2] EXTERNAL TABLE
-- Reference : dbrang.tistory.com
-- Key word : external table 외부 테이블
****************************************************************************************************************/
$ vi ttt.txt
1,aaaaa,AAAAA,123
2,bbbbb,BBBBB,234
3,ccccc,CCCCC,3453
4,ddddd,DDDDD,23
5,eeeee,EEEEE,234


CREATE EXTERNAL TABLE MY_TBL (X text) 
LOCATION (
 'gpfdist://host:8001/file1.txt',
 'gpfdist://host:8002/file2.txt'
) FORMAT 'TEXT' (DELIMITER '|' NULL '')



반응형

+ Recent posts