hive HA配置

1、zookeeper、hadoop安装好，启动

2、hive-site.xml增加，分发

<!-- hive ha -->
<property>
<name>hive.server2.support.dynamic.service.discovery</name>
<value>true</value>
</property>

<property>
<name>hive.server2.zookeeper.namespace</name>
<value>hiveserver2_zk</value>
</property>

<property>
<name>hive.zookeeper.quorum</name>
<value>node1:2181,node2:2181,node3:2181</value>
</property>

<property>
<name>hive.zookeeper.client.port</name>
<value>2181</value>
</property>

<!-- 这两项在之前文档配置过，第一个是server2的主机名，第二个是端口号-->
<property>
<name>hive.server2.thrift.bind.host</name>
<value>0.0.0.0</value>
<value>我写的是前的主机名</value>
</property>
<property>
<name>hive.server2.thrift.port</name>
<value>10000</value>
</property>

启动hiveserver2、metastore服务的时候，得打开hadoop集群，否则初始化的文件夹会建在本地

3、thrift服务高可用

<property>
 <name>hive.metastore.uris</name>
 <value>thrift://dw1:9083,thrift://dw2:9083</value>
 <description>A comma separated list of metastore uris on which metastore service is running</description>
</property>
<property>
 <name>hive.cluster.delegation.token.store.class</name>
 <value>org.apache.hadoop.hive.thrift.MemoryTokenStore</value>
 <description>Hive defaults to MemoryTokenStore, or ZooKeeperTokenStore</description>
</property>

4、启动各个节点的 thrift、server2

5、beeline连接

!connect jdbc:hive2://node1:2181,node2:2181,node3:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2_zk root root

6、测试

kill  metastore  server2测试

hive搭建地址：https://mp.csdn.net/postedit/86388705

参考大数据田地：http://lxw1234.com/archives/2016/05/675.htm