如何使用Hadoop的Partitioner
3 回答
翻過高山走不出你
TA貢獻1875條經驗 獲得超3個贊
創建表
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;
- 3 回答
- 0 關注
- 1242 瀏覽
添加回答
舉報
0/150
提交
取消