Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-11581

HiveServer2 should store connection params in ZK when using dynamic service discovery for simpler client connection string.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.3.0, 2.0.0
    • 1.3.0, 2.0.0
    • HiveServer2, JDBC

    Description

      Currently, the client needs to specify several parameters based on which an appropriate connection is created with the server. In case of dynamic service discovery, when multiple HS2 instances are running, it is much more usable for the server to add its config parameters to ZK which the driver can use to configure the connection, instead of the jdbc/odbc user adding those in connection string.

      However, at minimum, client will need to specify zookeeper ensemble and that she wants the JDBC driver to use ZooKeeper:

      beeline> !connect jdbc:hive2://vgumashta.local:2181,vgumashta.local:2182,vgumashta.local:2183/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 vgumashta vgumashta org.apache.hive.jdbc.HiveDriver

      Attachments

        1. HIVE-11581.1.patch
          34 kB
          Vaibhav Gumashta
        2. HIVE-11581.2.patch
          34 kB
          Vaibhav Gumashta
        3. HIVE-11581.3.patch
          34 kB
          Vaibhav Gumashta
        4. HIVE-11581.3.patch
          34 kB
          Vaibhav Gumashta
        5. HIVE-11581.4.patch
          34 kB
          Vaibhav Gumashta

        Issue Links

          blocks

          Bug - A problem which impairs or prevents the functions of the product. NIFI-2575 HiveQL Processors Fail due to invalid JDBC URI resolution when using Zookeeper URI

          • Major - Major loss of function.
          • Open
          is related to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-11932 JDBC Driver appends an extra "/" when configuring connection by reading httpPath from ZooKeeper

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. HIVE-12280 HiveConnection does not try other HS2 after failure for service discovery

          • Major - Major loss of function.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-11555 Beeline sends password in clear text if we miss -ssl=true flag in the connect string

          • Major - Major loss of function.
          • Open

          Bug - A problem which impairs or prevents the functions of the product. HIVE-11875 JDBC Driver does not honor delegation token mechanism when readings params from ZooKeeper

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. HIVE-12500 JDBC driver not overlaying params supplied via properties object when reading params from ZK

          • Major - Major loss of function.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. HIVE-13326 HiveServer2: Make ZK config publishing configurable

          • Major - Major loss of function.
          • Closed
          links to

          Web Link Review Board

          mentioned in

          Page Loading...

          Activity

            People

              vgumashta Vaibhav Gumashta
              vgumashta Vaibhav Gumashta
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: