Hive 建表语句模板和引入数据

create table nsrxx(
hydm string
,nsr_id string
,djzclx_dm string
,kydjrq string
,xgrq string
,label string
)
row format delimited
fields terminated by ','
lines terminated by ' ';

create table zzsfp(
fp_nid string
,xf_id string
,gf_id string
,je string
,se string
,jshj string
,kpyf string
,kprq string
,zfbz string
)
row format delimited
fields terminated by ','
lines terminated by ' ';

create table zzsfp_hwmx(
fp_nid string
,date_key string
,hwmc string
,ggxh string
,dw string
,sl string
,dj string
,je string
,se string
,spbm string
)
row format delimited
fields terminated by ','
lines terminated by ' ';

create table sales(
day_id string
,sale_nbr string
,buy_nbr string
,cnt string
,round string
)
row format delimited
fields terminated by ','
lines terminated by ' ';

load data local inpath '/opt/software/data/sales.txt' overwrite into table sales;