hive建表指定分隔符

create table dl.tg_srms_t_sc_supplier(
id                string comment '                        ',
supplier_name     string comment '                        ',
supplier_abbr     string comment '                        ',
sup_tel           string comment '电话                    ',
nation_diff       string comment '1:国内；2；国外；       ',
nation_id         string comment '常数管理                ',
load_time         string comment '数据抽取时间            ',
biz_date          string comment '                        ')
ROW FORMAT DELIMITED
FIELDS TERMINATED BY ','
STORED AS TEXTFILE;

加载本地数据文件到表里

hive>LOAD DATA LOCAL INPATH '/risk/dwd_risk_province_city.txt' OVERWRITE  INTO TABLE dwd_risk_province_city;