Connecting to your Hive data

The JDBC Connector to retrieve data from Hive can be configured using the “Other JDBC” option. A JDBC named query can be used to submit a custom SQL query to Hive and retrieve the results using the JDBC Connector.

This topic describes how to configure the Hive JDBC Connector to access Hive. When Hive is configured for access with JDBC, the Hive user impersonation setting must be taken into account, as well as whether or not the Hadoop cluster is secured with Kerberos.

JDBC Server Configuration

The JDBC Connector is installed with the JAR files required to access Hive via JDBC, hive-jdbc-<version>.jar and hive-service-<version>.jar, and automatically registers these JARs.

When a JDBC server is configured for Hive access, the JDBC driver class name must be specified, database URL, and client credentials just like configuring a client connection to an SQL database.

To access Hive via JDBC, the following properties must be specified and values in the jdbc-site.xml server configuration file must be entered:







The value of the HiveServer2 authentication (hive.server2.authentication) and impersonation (hive.server2.enable.doAs) properties, and whether or not the Hive service is utilizing Kerberos authentication, will inform the setting of other JDBC server configuration properties. These properties are defined in the hive-site.xml configuration file in the Hadoop cluster. It will be needed to obtain the values of these properties.

Hive JDBC Driver

The latest Hive JDBC driver can be downloaded from the Maven Hive JDBC driver repository

Download the driver and place it in /opt/zetaris/server/lightning/jdbc-lib/ inside the server container

Loading Hive JDBC driver into Zetaris

Step 1: Start the container/service

Step 2: Download the driver

Step 3: Place it in /home/zetaris/.../jdbc-lib/

Step 4: Stop container /service


Example: Connection pane window from the NDP Data Fabric Builder connecting to Hive: