首頁猿問如何使用Hadoop的Partit...

如何使用Hadoop的Partitioner?

Hadoop

偶然的你 2019-01-29 07:07:59

如何使用Hadoop的Partitioner

查看完整描述

3 回答

翻過高山走不出你

TA貢獻(xiàn)1875條經(jīng)驗(yàn) 獲得超3個贊

創(chuàng)建表
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';
分區(qū)---------》

insert overwrite table pageView5 partition (hours,mm)
select *,substr(track_time,12,2),substr(track_time,15,2) from pageView4 limit 500;