hive 访问hbase表

最新推荐文章于 2024-11-13 23:04:55 发布

xiao_jun_0820

最新推荐文章于 2024-11-13 23:04:55 发布

阅读量2.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： hbase hive

本文链接：https://blog.youkuaiyun.com/xiao_jun_0820/article/details/34434167

hive 同时被 2 个专栏收录

32 篇文章

订阅专栏

hbase

27 篇文章

订阅专栏

首先创建外部表：

 create external table hbase_mobile_info(key string,city string,dealtime string,imsi string,manufacturer string,meid string,model string,province string, regtime string,version string)
 stored by 'org.apache.hadoop.hive.hbase.HBaseStorageHandler' 
 with serdeproperties ("hbase.columns.mapping" = ":key,fr:CITY,fr:DEALTIME,fr:IMSI,fr:MANUFACTURER,fr:MEID,fr:MODEL,fr:PROVINCE,fr:REGTIME,fr:VERSION") 
 tblproperties("hbase.table.name" = "mobile_info");

然后编辑hive-site.xml,添加如下配置：

<property>
   <name>hive.aux.jars.path</name>
   <value>file:///home/hadoop/cdh4.2.2/hive/lib/hive-hbase-handler-0.10.0-cdh4.2.2.jar,file:///home/hadoop/cdh4.2.2/hive/lib/hbase-0.94.2-cdh4.2.2.jar,file:///home/hadoop/cdh4.2.2/hive/lib/zookeeper-3.4.5-cdh4.2.2.jar</value>
</property>

否则查询hbase表的时候会出现报错：
java.io.IOException: Cannot create an instance of InputSplit class = org.apache.hadoop.hive.hbase.HBaseSplit:org.apache.hadoop.hive.hbase.HBaseSplit