如何使用Hadoop的Partitioner?

Question

如何使用Hadoop的Partitioner

Answer 1

创建表create table pageView5(track_time string,url string,session_id string,referer string,ip string,end_user_id string,city_id string)partitioned by (hours string ,mm string)row format delimited fields terminated by '\001'location '/user/beicai/hive4';分区---------》insert overwrite table pageView5 partition (hours,mm)select *,substr(track_time,12,2),substr(track_time,15,2) from pageView4 limit 500;