首先需要一次搭建好hadoop,hive,hbase的环境,参考文档如下:
http://blog.csdn.net/kunshan_shenbin/article/details/52933499
http://blog.csdn.net/kunshan_shenbin/article/details/52938294
http://blog.csdn.net/kunshan_shenbin/article/details/52944973
整合hive和hbase其实很简单。
首先,在$HIVE_HOME/conf/hive-site.xml文件中添加如下内容:
<property>
<name>hive.querylog.location</name>
<value>/Users/bin.shen/BigData/hive-2.1.0/logs</value>
</property>
<property>
<name>hive.aux.jars.path</name>
<value>
file:///Users/bin.shen/BigData/hive-2.1.0/lib/hive-hbase-handler-2.1.0.jar,
file:///Users/bin.shen/BigData/hive-2.1.0/lib/guava-14.0.1.jar,
file:///Users/bin.shen/BigData/hbase-1.2.3/lib/hbase-common-1.2.3.jar,
file:///Users/bin.shen/BigData/hbase-1.2.3/lib/hbase-client-1.2.3.jar,
file:///Users/bin.shen/BigData/hbase-1.2.3/lib/hbase-server-1.2.3.jar,
file:///Users/bin.shen/BigData/hbase-1.2.3/lib/hbase-hadoop2-compat-1.2.3.ja,
file:///Users/bin.shen/BigData/hbase-1.2.3/lib/netty-all-4.0.23.Final.jar,
file:///Users/bin.shen/BigData/hbase-1.2.3/lib/hbase-protocol-1.2.3.jar,
file:///Users/bin.shen/BigData/zookeeper-3.4.9/zookeeper-3.4.9.jar
</value>
</property>
然后重启hive即可。
测试可参考如下网页:
https://ask.hellobi.com/blog/ambition119/3719
更多资料:
http://www.itweet.cn/2016/07/03/hive-connect-hbase-test/
http://www.cnblogs.com/MOBIN/p/5704001.html
http://blog.csdn.net/l192168134/article/details/51906924