问使用配置单元外部表中的组分隔符(GS)作为分隔符

EN

CREATE EXTERNAL TABLE IF NOT EXISTS icephase2Demo.GS_TEST1
(
RandomString1 String,
RandomString2 String
)
ROW FORMAT DELIMITED
FIELDS TERMINATED BY '\35'
LINES TERMINATED BY '\n'
STORED AS TEXTFILE
LOCATION '/DataSourcing/DV_POC/GS_TEST/';

load data inpath '/DataSourcing/DV_POC/groupseperatorOutput.dat' into table icephase2Demo.GS_TEST1;

hive> select * from GS_TEST1;