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.