Previous Topic
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