Integrating Apache Hive with Kafka, Spark, and BI
Also available as:

Locate the JDBC or ODBC driver

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

Hortonworks provides the JDBC driver as part of the HDP distribution, and provides an ODBC driver as an add-on to the distribution for HDP support subscription customers.
  1. Get the driver.
    • In Ambari, navigate to Services > Hive > Summaryand in Quick Links, click Jdbc Standalone Jar Download.
    • On a cluster node, navigate to /usr/hdp/current/hive-client/lib to locate the Hortonworks driver hive-jdbc.jar that HDP installed on your cluster.
    • Download the JDBC driver hive-jdbc from the driver archive.
    • Download the ODBC driver for Apache Hive 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.