Locate the JDBC or ODBC driver
You download the JDBC driver, navigate to the installed JDBC driver, or you download the ODBC driver.
Get the driver.
- In Ambari, navigate to and 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.
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