hiveJdbc ha 链接报错

java hive execute org.apache.hadoop.hive.ql.exec.mr.MapRedTask 

安装的是hive2  然后java执行hive 直接select* from table 没有问题 但是带有mr的会包这个错，

然后beeline连接执行查看是版本问题换成

1.2.就ok了

org.apache.hive.jdbc.ZooKeeperHiveClientException: Unable to read HiveServer2 uri from ZooKeeper

该错误调试了好长时间，最后无意中发现 hive-site.xml中的配置项：hive.server2.thrift.bind.host 为0.0.0.0

然后查看zk中写入的也是0.0.0.0:10000

然后重启将该项改为本机Ip重启就OK看了

hive注册zk的ha配置：

http://lxw1234.com/archives/2016/05/675.htm

1. <property>
2. <name>hive.server2.support.dynamic.service.discovery</name>
3. <value>true</value>
4. </property>
5.  
6. <property>
7. <name>hive.server2.zookeeper.namespace</name>
8. <value>hiveserver2_zk</value>
9. </property>
10.  
11. <property>
12. <name>hive.zookeeper.quorum</name>
13. <value> zkNode1:2181,zkNode2:2181,zkNode3:2181</value>
14. </property>
15.  
16. <property>
17. <name>hive.zookeeper.client.port</name>
18. <value>2181</value>
19. </property>
20.  
21.  
22. <property>
23. <name>hive.server2.thrift.bind.host</name>
24. <value>0.0.0.0</value> //改为本机Ip
25. </property>
26.  
27. <property>
28. <name>hive.server2.thrift.port</name>
29. <value>10001</value> //两个HiveServer2实例的端口号要一致
30. </property>

hadoop的core-site.xml

1. <property>
2. <name>hadoop.proxyuser.abc.groups</name>
3. <value>*</value>
4. </property>
5.  
6. <property>
7. <name>hadoop.proxyuser.abc.hosts</name>
8. <value>*</value>
9. </property>
10. 
    

刷新权限

yarn rmadmin -refreshSuperUserGroupsConfiguration

hdfs dfsadmin -refreshSuperUserGroupsConfiguration

beeline连接方式：!connect jdbc:hive2://yun01:2181,yun02:2181,yun03:2181,yun04:2181,yun05:2181/weather_eva_db;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2_zk abc ""