如何使用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;