...
For more information, see API Connections Create v3.
Additional Configuration Options
...
Configure Hive connection for high availability availability
Minimum requirements:
Info |
---|
NOTE: High availability for Hive is supported for HDP 2.6 or HDP 3.0 using Hive 2.x only. Other Hive integrations are not supported. |
- Multiple Hive servers and metastores are required.
- A minimum of three Zookeeper server is required.
Steps:
- Login to Ambari.
- In the left nav bar, select Hive.
- Copy the HiveServer2 JDBC URL to the clipboard.
Paste it into a text editor. Example:
Code Block jdbc:hive2://thdp-m-1-20190226193250.c.t-dev:2181,thdp-w-2-20190226193418.c.t-dev:2181/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
- When you create the connection in
:D s product Host: Specify the hosts listed in the JDBC URL, removing the protocol and port identifiers. From the above example, the value is the following:
Code Block thdp-m-1-20190226193250.c.t-dev:2181,thdp-w-2-20190226193418.c.t-dev
Port Number: From the example, it is this value:
Code Block 2181
Connect String Options: From the example, you must prepend the remainder with the identifier of the principal, as in the following:
Code Block ;principal=hive/_HOST@HORTONWORKS;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2
- Specify the other properties accordingly.
- To test:
- Run a job sourced from the first Hive server.
- If possible, disable the first listed Hive server to test failover access.
...