...

For more information, see API Connections Create v3.

Additional Configuration Options

...

Configure Hive connection for high availability availability

Minimum requirements:

• Multiple Hive servers and metastores are required.
• A minimum of three Zookeeper server is required.

Steps:

1. Login to Ambari.
2. In the left nav bar, select Hive. 
3. Copy the HiveServer2 JDBC URL to the clipboard.

4. 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

   
   

5. When you create the connection in 

   D s product

   :

   1. 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

      
      

   2. Port Number: From the example, it is this value:
      
      

      Code Block
      2181

      
      

   3. 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

      
      

6. Specify the other properties accordingly. 
7. To test:
   1. Run a job sourced from the first Hive server.
   2. If possible, disable the first listed Hive server to test failover access.

...