Skip to content
This repository has been archived by the owner on Oct 1, 2024. It is now read-only.

Latest commit

 

History

History
41 lines (27 loc) · 2.17 KB

GETTING-STARTED.md

File metadata and controls

41 lines (27 loc) · 2.17 KB
Raw

Getting Started

To begin using, download the appropriate driver version here. Again, there are four flavors of the driver jar corresponding to different connection mechanisms:

  • Binary: for binary connections without zookeeper discovery support
  • Binary + Zookeeper: for binary connections that leverage zookeeper discovery
  • HTTP: for http connections without zookeeper discovery support
  • HTTP + Zookeeper: for http connections that leverage zookeeper discovery

All driver versions use the same JDBC URL format but have different Driver classnames. The JDBC URL format differs from the Apache Hive version in the way it delimits properties. For example the general format for connections strings is as follows:

// New URL format
jdbc:hive2://[host]:[port]/[database]?[key=value]&[key=value]

Please note the following:

  • The database must follow host and port and start with a /. It corresponds to URI.getPath().
  • Key/Value pairs follow the database name and begin with a ?. Additional Key/Value pairs are delimited by &. Key/Value pairs correspond to URI.getQuery().

This approach is different from the Apache Hive version which generally uses the following format.

// Apache Hive URL format
jdbc:hive2://[host]:[port]/[database];[key=value];[key=value]

Notice the exclusive use of ; to separate the database from Key/Value pairs as well as additional Key/Value pairs. This approach leads to rather complicated parsing logic without providing a clear benefit. For more details on the Apache Hive format see this.

Binary Driver

The Binary driver is intended to be used with clusters where hive.server2.transport.mode is set to binary and Zookeeper discovery is not enabled. The classname for this driver is veil.hdp.hive.jdbc.BinaryHiveDriver.

Example URLs

# simplest form
jdbc:hive2://somehost:10000/default