1.hive建表

create EXTERNAL table IF NOT EXISTS  exttable_map_mdn_city(sdate string,mdn string,province string,city string,times int)partitioned by (dt string) ROW FORMAT DELIMITED FIELDS TERMINATED BY ',' location '/user/noc/private/exttable_map_mdn_city/';

hive -e "use noc_dpi;alter table exttable_map_mdn_city add partition (dt='$lastday') location '/user/noc/private/ext_tables/exttable_map_mdn_city/$lastday' "

2. hive中文只支持UTF-8编码

iconv   -f gbk -t utf-8
    
     mpm_tot_$lastday.datrm mpm_tot_$lastday.txtmv mpm_tot_$lastday.dat mpm_tot_$lastday.txt
    

3.文件入库

hadoop fs -put mpm_tot_201601$i.txt /user/noc/private/ext_tables/exttable_map_mdn_city/$lastdayls mpm_tot_$lastday.txthadoop fs -du /user/noc/private/ext_tables/exttable_map_mdn_city/20160131