JDBC#

Querona supports JDBC as a general data provider. Standard JDBC connection strings can be used to configure a connection to any data source that has a JDBC driver.

Note

Querona hosts Java Virtual Machine (JVM) internally and performs all the driver initialization for you, so no additional Java installation is required.

JDBC Industry Support#

For a list of the companies that have endorsed the JDBC database access API and have built or are building JDBC-based products, please navigate to Oracle’s site.

JDBC prerequisites#

Before JDBC can be used, all required drivers need to be configured in Querona. Some JDBC drivers are distributed with Querona if licensing allows for it. Drivers not distributed need to be donloaded and installed (copied).

How to configure a connection using JDBC#

Out of the box Querona delivers a SQL Dialect for Hive over JDBC, but drivers need to be downloaded from the vendor site.

Here is a short list of JDBC drivers that may be of interest:

Data source name

Vendor

Download page

Hive

Cloudera

Hive JDBC driver

Impala

Cloudera

Impala JDBC driver

Step 1, download Hive drivers#

Click a Hive JDBC driver link and download the latest driver. Unpack them if necessary.

Step 2, Create a folder on Querona server and copy drivers#

Access Querona server local drive using an UNC path or a Remote Desktop connection, and create a folder that will hold the driver. Next, copy the downloaded drivers into the folder of your choosing.

Note

In this article we assume the folder c:\programdata\queronajdbc.

Step 3, configure the driver folder and register it in Querona#

Querona needs to know where to look for JDBC drivers during boot. To configure that folder please navigate to ADMINISTER ‣ Engine configuration and click Edit. Scroll down and enter the folder name into textbox labeled Built-in JVM classpath (csv). It holds the comma-separated list of folders that Querona will use to search and load the drivers it finds.

Step 4, create a new connection using Hive dialect#

Follow the instructions describing how to create a connection to a source database available at Create a connection.

See also#