hive命令

create table if not exists KLFX_DB.TW_PERS_NIL_PROVINCE_CITY(id String ,province_code String, city_code String,province String,city String );

create table if not exists KLFX_DB.nil_imsi_country(id String ,country String,imsi_seg String);

外部表
create external table t_area_cgi(id int,name string)
row format delimited fields terminated by ‘\t’location ‘/tenant/bmjs/ISD/WZYY/KLSSYY/KLFX/parquet/t_area_cgi’ ;

load data local inpath ‘/usr/local/t_area_cgi.txt’ into table t_area_cgi;