GBase8a只读外部表创建方法

txt格式只读外部表

CREATE LOAD READ EXTERNAL TABLE "t1" (
  "id" int(11) DEFAULT NULL,
  "name" varchar(20) DEFAULT NULL,
  "message" varchar(20) DEFAULT NULL,
  "fileid" int(11) DEFAULT NULL
)  LOCATION 'ftp://gbase:gbase@172.16.4.21//home/gbase/test/data/a.txt'
INFORMAT  DATA_FORMAT 3 FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n' OUTFORMAT;

csv格式只读外部表

CREATE LOAD READ EXTERNAL TABLE "t2" (
  "id" int(11) DEFAULT NULL,
  "name" varchar(20) DEFAULT NULL,
  "message" varchar(20) DEFAULT NULL,
  "fileid" int(11) DEFAULT NULL
)  LOCATION 'ftp://gbase:gbase@172.16.4.21//home/gbase/test/data/a.csv'
INFORMAT  DATA_FORMAT 3 FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' OUTFORMAT;

parquet格式只读外部表

CREATE LOAD READ EXTERNAL TABLE "t3" (
  "id" int(11) DEFAULT NULL,
  "name" varchar(20) DEFAULT NULL,
  "message" varchar(20) DEFAULT NULL,
  "fileid" int(11) DEFAULT NULL
)  LOCATION 'ftp://gbase:gbase@172.16.4.21//home/gbase/test/data/a/*'  INFORMAT  DATA_FORMAT 9 OUTFORMAT;