hive文本文件导入

drop table pos_store46code ;

create table pos_store46code  (

A string,

B string,

C string,

D string,

E string)

ROW format delimited fields terminated by'\t' STORED AS TEXTFILE;

load data local inpath '/home/lmeng/belle/fin_data/pos_store46code' into table pos_store46code ;