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 site.

JDBC prerequisites

Before JDBC can be used, all required drivers need to be configured in Querona. No JDBC drivers are distributed with Querona due to licensing restrictions, therefore it is an administrator’s responsibility to download drivers needed and configure them in Querona.

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.

Because the classpath folder is scanned only during Querona service boot, it is necessary to restart Querona service.

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.