Cloudera Docs

Get the JDBC or ODBC driver

You download the Apache Hive JDBC driver, navigate to the installed JDBC driver, or you download the Simba ODBC driver.

Cloudera provides the Apache Hive JDBC and Simba ODBC drivers as an add-on. When you start the Hive shell, the JDBC JAR version to use appears in the output: 
. . .
Connected to: Apache Hive (version 3.1.2000.7.0.3.0-117)
Driver: Hive JDBC (version 3.1.2000.7.0.3.0-117)
Transaction isolation: TRANSACTION_REPEATABLE_READ
Beeline version 3.1.2000.7.0.3.0-117 by Apache Hive
0: jdbc:hive2://172.27.133.67:10000/default>
  1. Get the driver.
    • Using the version number of Apache Hive in your cluster, search for and download the standalone Apache Hive JDBC driver from the Central Maven repository.
    • Download the Simba ODBC driver for Hive in CDP from the Cloudera Downloads page. Skip the rest of the steps in this procedure and follow ODBC driver installation instructions on the same downloads page.
  2. Give clients outside of the cluster who want to use the JDBC driver in HTTP and HTTPS modes access to required JARS:
    • /opt/cloudera/parcels/CDH-<version>/jars/hive-jdbc-<version>-standalone.jar
    • hadoop-common.jar

      For example, /opt/cloudera/parcels/CDH-7.0.0-1.cdh7.0.0.p0.1316065/lib/hadoop/hadoop-common.jar

    • hadoop-auth.jar

      Same location as hadoop-common.jar