Apache HIVE#

Apache HIVE driver is not bundled with Querona, and needs to be installed before use.

Querona supports the following options:

Free, JDBC HIVE driver from Cloudera#

A free Hive driver uses a built-in JDBC connectivity and Cloudera Hive JDBC driver. Please read Cloudera’s’ license terms and download the driver from Cloudera’s website. Place the downloaded driver in a directory on a machine hosting Querona - usually in %ProgramData%\Querona\jdbc.

Configuration of the JDBC driver#

All JDBC drivers utilize a built-in JRE ditributed with Querona. To configure, create a connection based on the JDBC provider, and provide values for the following parameters:

Name

Value/Example value

Dialect

Hive JDBC

Connection string

DriverPath=<path_to_file>\HiveJDBC42.jar;DriverClass=com.cloudera.hive.jdbc.HS2Driver;

JDBC Url

jdbc:hive2://<server_name>:10000/default

Username

Username to use when connecting to Hive

Password

Password to use when connecting to Hive

Connection properties

Optional connection properties, if required

Commercial Hive driver from CData#

A trial of the commercial Hive driver from CData can be obtained from CData’s website. Please download the ADO.Net version of the driver.

Configure a new connection using a Hive dialect.