Accessing Data via Hive Connections

This topic introduces Hive connections and lists the libraries you need to provide when using Hive connections in Designer.

A Hive connection functions the same as a JDBC connection. It supplies the JDBC driver and metadata information which are the same as JDBC. However, it expands many native functions to support non-SQL and huge data that JDBC does not support.

To set up Hive connections in Designer, you need to add the corresponding Hive database drivers to <designer_install_root>\lib, or append the archive files of the drivers to the ADDCLASSPATH variable of setenv.bat in <designer_install_root>\bin. The following lists the libraries that support Hive 0.12.0. When you use later Hive versions, you can replace them with new jars.

hadoop-common-2.2.0.jar
hadoop-core-2.2.0.jar
hive-exec-0.12.0.jar
hive-jdbc-0.12.0.jar
hive-metastore-0.12.0.jar
hive-service-0.12.0.jar
libfb303-0.9.0.jar
libthrift-0.9.0.jar
slf4j-api-1.7.25.jar
slf4j-simple-1.6.1.jar

Previous Topic Next Topic