Data Connection to Hadoop Hive

Version

Application Scenario

Hadoop is a common and distributed computing solution. Hive is a data warehouse architecture based on Hadoop.

This document introduces how to connect to the Hadoop Hive data source.

Note:

This database does not support data tables with direct connection attributes.

Version and Driver

Download the driver according to the database version and upload it to FineBI. For details, see section "Creating a Data Connection" in Driver Management.

Note:

During driver package upload, you need to decompress the Log JAR file below and upload it to FineBI together with the driver package.

Connection Information Collection

Before connecting the database to FineBI, you need to collect the following information:

• IP address and port number of the database server

• Database name

• Username and password (for username and password authentication); client principal and keytab file path (for Kerberos authentication)

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, click Create, and select Data Connection, as shown in the following figure.

Note:

 If you are not the admin, you can configure data connections only after the admin assigns you the permission on Data Connection Management. For details, see Data Connection Permission Overview.

2. Find the Hadoop Hive icon, as shown in the following figure.

3. Select Custom from the Driver drop-down list, select the driver uploaded in section "Version and Driver", and enter the connection information collected in section "Connection Information Collection", as shown in the following figure.

For details about Kerberos authentication, see Kerberos Authentication in Data Connection.

To use Kerberos authentication, you need to pay attention to the following points.

• Check whether the IP address corresponding to the machine name in /etc/hosts is a LAN IP address.

• Check whether the machine name set in /etc/hostname is consistent with that set in /etc/hosts.

• Check whether the IP address and machine name in the hosts file of the machine where FineBI is located are correct.

• In some cases, especially in non-public network environments, your client may not be able to resolve the host name of the database server. In this case, you need to configure the client's file in /etc/hosts and add remote mapping (IP address and host name, for example, 192.168.5.206 centos-phoenix).

4. Click Test Connection. If the connection is successful, click Save, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets