...
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 |
|---|
| server | ASF JIRA |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 5aa69414-a9e9-3523-82ec-879b028fb15b |
|---|
| key | HIVE-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 |
|---|
| server | ASF JIRA |
|---|
| columns | key,summary,type,created,updated,due,assignee,reporter,priority,status,resolution |
|---|
| serverId | 5aa69414-a9e9-3523-82ec-879b028fb15b |
|---|
| key | HIVE-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.
...