Obtain and Install Drivers for Hive
To obtain JDBC drivers for Hive
1. From the web, locate the Hive zip files.
Choose your version from the following download locations and download hive-<version>-bin.tar.gz.:
— For instructions on using Hive JDBC driver with Kerberos, refer
Refer to the TDV Installation guide for more details about the supported versions.
2. Unpack the zip file.
3. Copy the following JAR files for your version
Version | JAR Files |
Apache Hive 2.x | commons-cli-1.2.jar commons-configuration-1.6.jar commons-logging-1.2.jar hadoop-auth-2.7.3.jar hadoop-common-2.7.3.jar hadoop-hdfs-2.7.3.jar hive-exec-2.1.1.jar hive-jdbc-2.1.1.jar hive-service-2.1.1.jar htrace-core-3.1.0-incubating.jar httpclient-4.4.jar httpcore-4.4.jar libfb303-0.9.3.jar libthrift-0.9.3.jar log4j-core-2.4.1.jar |
4. From the Apache Hadoop web site, locate and copy the hadoop-core-1.2.1.jar file.
To install the JDBC drivers for Hive
Make sure to add the JAR files to all of your TDV clients and servers.
1. Paste the necessary driver JAR files into the following TDV installation directory (or the directory for your specific version):
<TDV_install_dir>\conf\adapters\system\hive2
2. Restart the TDV Server.
To enable Kerberos authentication:
Configure the following JDBC connection URL to authenticate the connecting user on the server Hiveserver2 with Kerberos:
jdbc:hive2://<host>:<port>/<dbName>;principal=<HiveServer2_kerberos_principal>;<otherSessionConfs>?<hiveConfs>#<hiveVars>