Integrating Apache Hive with Spark and BI
Also available as:
PDF

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 Hortonworks JDBC driver from the Hive JDBC driver archive.
    • Download the ODBC driver https://hortonworks.com/downloads/ > Addons. 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.