如何使用Hadoop的Partitioner
3 回答
翻過(guò)高山走不出你
TA貢獻(xiàn)1875條經(jīng)驗(yàn) 獲得超3個(gè)贊
創(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;
- 3 回答
- 0 關(guān)注
- 1257 瀏覽
添加回答
舉報(bào)
0/150
提交
取消