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.
- 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/products/data-platforms/hdp/. 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