Hiveserver2 high availability from beeline

Step 1:

 Edit hive-site.xml on every hs2 node

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


<property>
        <name>hive.zookeeper.quorum</name>
        <value>mfs071:5181,mfs072:5181,mfs073:5181</value>
</property>

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


Steps 2

Restart hs2


Steps 3

 Connect via beeline

!connect jdbc:hive2://mfs071:5181,mfs072:5181,mfs073:5181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2


[mapr@mfs072 ~]$ /opt/mapr/hive/hive-1.2/bin/beeline
Beeline version 1.2.0-mapr-1601 by Apache Hive
beeline> !connect jdbc:hive2://mfs071:5181,mfs072:5181,mfs073:5181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Connecting to jdbc:hive2://mfs071:5181,mfs072:5181,mfs073:5181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
Enter username for jdbc:hive2://mfs071:5181,mfs072:5181,mfs073:5181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: mapr
Enter password for jdbc:hive2://mfs071:5181,mfs072:5181,mfs073:5181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2: ****
Connected to: Apache Hive (version 1.2.0-mapr-1601)
Driver: Hive JDBC (version 1.2.0-mapr-1601)
Transaction isolation: TRANSACTION_REPEATABLE_READ
0: jdbc:hive2://mfs071:5181,mfs072:5181,mfs07> show databases;
+----------------+--+
| database_name  |
+----------------+--+
| default        |
+----------------+--+
1 row selected (0.178 seconds)