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.4.patch
          34 kB
          Vaibhav Gumashta
        2. HIVE-11581.3.patch
          34 kB
          Vaibhav Gumashta
        3. HIVE-11581.3.patch
          34 kB
          Vaibhav Gumashta
        4. HIVE-11581.2.patch
          34 kB
          Vaibhav Gumashta
        5. HIVE-11581.1.patch
          34 kB
          Vaibhav Gumashta

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: