Integrating Apache Hive with Spark and BI
Also available as:

Locate 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 driver as part of the HDP distribution, and provides a Simba ODBC driver as an add-on to the distribution for HDP support subscription customers.
  1. Get the driver.
    • On a cluster node, navigate to /usr/hdp/current/hive-client/lib to locate the Apache Hive driver hive-jdbc.jar that HDP installed on your cluster.
    • Using the version number of the JAR in /usr/hdp/current/hive-client/lib, download the same Apache Hive JDBC driver hive-jdbc from the driver archive.
    • Download the Simba ODBC driver from the Cloudera downloads page. Skip the rest of the steps in this procedure and follow ODBC driver installation instructions.
  2. Optionally, if you run a host outside of the Hadoop cluster, to use the JDBC driver in HTTP and HTTPS modes, give clients access to hive-jdbc-<version>-standalone.jar, hadoop-common.jar, and hadoop-auth.jar.