hive连接HBase

​关闭掉hbase，zookeeper和hive服务

[root@gree143 conf]# stop-hbase.sh

[root@gree143 conf]# zkServer.sh stop

[root@gree143 conf]# stop-all.sh

进入hive312/conf

[root@gree143 /]# cd /opt/soft/hive312/conf/

修改hive-site.xml配置

[root@gree143 conf]#vim hive-site.xml

在代码最后添加配置

<property>

<name>hive.zookeeper.quorum</name>

<value>192.168.61.146</value>

</property>

<property>

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

<value>192.168.61.146</value>

</property>

<property>

<name>hive.aux.jars.path</name>

<value>file:///opt/soft/hive312/lib/hive-hbase-handler-3.1.2.jar,file:///opt/soft/hive312/lib/zookeeper-3.4.6.jar,file:///opt/soft/hive312/lib/hbase-client-2.3.5.jar,file:///opt/soft/hive312/lib/hbase-common-2.3.5-tests.jar,file:///opt/soft/hive312/lib/hbase-server-2.3.5.jar,file:///opt/soft/hive312/lib/hbase-common-2.3.5.jar,file:///opt/soft/hive312/lib/hbase-protocol-2.3.5.jar,file:///opt/soft/hive312/lib/htrace-core-3.2.0-incubating.jar</value>

</property>

查看一下在hbase235中lib目录下的jar包

[root@gree143 conf]#ll /opt/soft/hbase235/lib

​编辑

将hbase235的jar包全部拷贝到hive312的lib目录，并且所有的是否覆盖信息全部输入n，不覆盖

[root@gree143 conf]#cp /opt/soft/hbase235/lib /opt/soft/hIve312/lib

查看hive312下面的guava，只保留27的guava

[root@gree143 lib]#find .../lib/guava*

删除除了27以外的所有guava

[root@gree143 lib]#rm -rf ../lib/guava-11.0.2.jar

​编辑 再将hbase235里面的除了27的guava全部删除

将hive312的27拷贝到hbase235的lib目录下

[root@gree143 lib]#cp /opt/soft/hive312/lib/guava-27.0-jre.jar ./

​编辑搞定，开始重新启动hadoop，zookeeper，hbase

启动hadoop: start-all.sh

启动runjar服务：

nohup hive --service hiveserver2 &

nohup hive --service metastore &

启动zk: zkServer.sh start

启hbase: start-hbase.sh

进入hbase shell查看一下，看一下启动是否成功即可

​