【案例】hive脚本加载数据到hive分区表
access_logs/20170610/2017061000.log
2017061001.log
2017061002.log
......
2017061023.log
二级分区:天/小时
crontab+shell 实现自动调度。
建库:
create database load_hive;
建表:
create table load_h(
id string,
url string,
referer string,
keyword string,
type string,
guid string,
pageId string,
moduleId string,
linkId string,
attachedInfo string,
sessionId string,
trackerU string,
trackerType string,
ip string,
trackerSrc string,
cookie string,
orderCode
access_logs/20170610/2017061000.log
2017061001.log
2017061002.log
......
2017061023.log
二级分区:天/小时
crontab+shell 实现自动调度。
建库:
create database load_hive;
建表:
create table load_h(
id string,
url string,
referer string,
keyword string,
type string,
guid string,
pageId string,
moduleId string,
linkId string,
attachedInfo string,
sessionId string,
trackerU string,
trackerType string,
ip string,
trackerSrc string,
cookie string,
orderCode