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 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.
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