CDH5 HIVE整合Hbase配置

除了常规的配置外需要做如下几个操作：

 1.将hbase lib下的hbase-*.jar和htrace-core-2.04.jar都拷贝到hive lib下；

 2.将hive lib下的hive-hbase-handler-1.1.0-cdh5.4.0.jar 拷贝到 hbase lib下

 3.将hbase中的zk配置添加到hive-site.xml中

<property>

            <name>hbase.zookeeper.quorum</name>

            <value>zkhost1,zkhost2,zkhost3</value>

 </property>

4. Hbase shell 下创建表

create 'user_profile','cf' 

put "user_profile",'user1','cf:lable1','4'

put "user_profile",'user1','cf:lable2','5'

5.hive创建Hbase的外部表

CREATE EXTERNAL TABLE  user_profile ( username STRING, labels map<string, string> )
STORED BY 'org.apache.hadoop.hive.hbase.HBaseStorageHandler'
WITH SERDEPROPERTIES ("hbase.columns.mapping" = ":key,cf:#s:b")
TBLPROPERTIES("hbase.table.name" = "user_profile"); 

6.结果:

hive> select * from user_profile;
OK
user1   {"lable1":"4","lable2":"5"}
Time taken: 0.418 seconds, Fetched: 1 row(s)
hive>