JDBC Driver

Qubole provides its own JDBC driver for Hive, Presto, and Spark. The Qubole JDBC jar can also be added as a Maven dependency. Here is an example POM.xml with dependency on the JDBC jar. Add the repositories, group, and artifact ID as mentioned in the above POM file. Change the version as required but Qubole recommends to add the latest version.

Qubole has two generations of JDBC driver broadly classified based on the functionalities they offer. Third-generation drivers are the latest drivers that come with several benefits. Second-generation and older driver versions are considered legacy.

Benefits of the Qubole JDBC Driver

The Qubole driver provides several advantages over the open-source JDBC drivers that are mentioned below:

• Queries are displayed in the QDS Analyze/Workbench page for a historical view.

• Users are authenticated through the Qubole account API Token.

• Qubole JDBC drivers support cluster lifecycle management (CLCM), cluster start/stop. The cluster does not have to be running all the time. Idle clusters are terminated by the Qubole Control Plane and queries executed through the Qubole JDBC driver brings the cluster up.

The topics below describe how to install and configure the JDBC driver before using it:

• Downloading the JDBC Driver
• Verifying the JDBC Driver Version
• Third-generation JDBC Driver
• Required Setup for Third-generation JDBC Driver
• Setting the JDBC Connection String
• Connecting to Qubole through the JDBC Driver
• Enabling Logging
• Enabling the Proxy Connection