Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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:

  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.

...