本地文件上传hive两步:
1.创建hive表
create table cf_tmp.sy_sms_0714(id int,tel int,category string,label string,content1 string,content2 string,channel string,source string,time string)
row format delimited
fields terminated by '\t' lines terminated by '\n'
stored as textfile;
2. load data local inpath 'XXXXX\' into talbe XXXXX
本地文件转换为txt,‘\t’分割列,‘\n’分割行。
hive 到 本地
hive> insert overwrite local directory '/home/wyp/wyp'
> select * from wyp;