Locate the JDBC or ODBC driver
You download the Apache Hive JDBC driver, navigate to the installed JDBC driver, or you download the Simba ODBC driver.
Get the driver.
- On a cluster node, navigate to /usr/hdp/current/hive-client/lib to locate the Apache Hive driver hive-jdbc.jar that HDP installed on your cluster.
- Using the version number of the JAR in /usr/hdp/current/hive-client/lib, download the same Apache Hive JDBC driver hive-jdbc from the driver archive.
- Download the Simba ODBC driver 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