Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: zk service discovery url

...

For versions earlier than 0.14, see the version note above.

 

Connection URL When Zookeeper Service discovery is enabled

Zookeeper based service discovery introduced in Hive 0.14.0 via 

Jira
serverASF JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId5aa69414-a9e9-3523-82ec-879b028fb15b
keyHIVE-7935
 enables high availability and rolling upgrade for HiveServer2. A JDBC url that specifies zookeeper quorum needs to be used to make use of these features.

With further changes in Hive 2.0.0, and 1.3.0 (unreleased) 

Jira
serverASF JIRA
columnskey,summary,type,created,updated,due,assignee,reporter,priority,status,resolution
serverId5aa69414-a9e9-3523-82ec-879b028fb15b
keyHIVE-11581
  none of the additional configuration parameters such as authentication mode, transport mode or ssl parameters need to be specified, as they are retrieved from the zookeeper entries along with the hostname.

The JDBC connection URL :  jdbc:hive2://<zookeeper quorum>/;serviceDiscoveryMode=zooKeeper;zooKeeperNamespace=hiveserver2 

The <zookeeper quorum> is same as the value of hive.zookeeper.quorum configuration parameter in hive-site.xml/hivserver2-site.xml used by hiveserver2.

Using JDBC

You can use JDBC to access data stored in a relational database or other tabular format.

...