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