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