我是靠谱客的博主 震动红牛,这篇文章主要介绍sqoop将hive中的数据导入mysql 查看hive表结构 hive新建内部表 mysql建表 hive 将增量数据导入hbase_visit_cp sqoop将数据导入mysql ,现在分享给大家,希望可以做个参考。
hive 数据通过sqoop 将增量数据导入mysql
查看hive表结构
- hive> desc hbase_visit;
- OK
- key string from deserializer
- insert_time string from deserializer
- label string from deserializer
- sessionid string from deserializer
- stay_time int from deserializer
- visit_time bigint from deserializer
- leave_time bigint from deserializer
- page_url string from deserializer
- referrer_url string from deserializer
- visit_number int from deserializer
- site string from deserializer
- ip string from deserializer
hive新建内部表
“ 01” 为分隔符- create table hbase_visit_cp(
- key_table varchar(100),
- insert_time varchar(20),
- label varchar(50),
- sessionid varchar(50),
- stay_time int,
- visit_time bigint,
- leave_time bigint,
- page_url varchar(2000),
- referrer_url varchar(2000),
- visit_number int,
- site varchar(20),
- ip varchar(20)
- ) row format delimited fields terminated by '