Data Connection to HBase

Version

Application Scenario

This document introduces how to connect to the HBase data source.

Note:

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

Version/Driver

Note: Place the driver package in hbase/lib, and restart HBase (using the commands ./stop-hbase.sh, and ./start-hbase.sh).

Connection Information Collection

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

• IP address and port number of the server where the database is located

• Database name

• Username and password (if username and password authentication is used); client principal and keytab file path (if Kerberos authentication is used)

• Schema of the database to be connected

1. Log in to FineBI as the admin, choose System Management > Data Connection > Data Connection Management, and click New 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 Permissions Overview.

2. Find the HBase icon, as shown in the following figure.

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

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

Note:

You can optionally modify other advanced settings. For details, see section "Advanced Settings" in Entry-Level Data Connection Configuration.

4. Click Click to Connect Database, and select the database schema after successful connection. (If no database schema is selected, the default schema will be used.) Finally, save the data connection, as shown in the following figure.

Two methods are available to add database tables to FineBI.

• Adding Database Tables

• Adding SQL Datasets

FineBI Always on the Startup Page

Problem:

After you place phoenix-4.12.0-HBase-1.2-client.jar in %FineBI%\webapps\webroot\WEB-INF\lib and restart FineBI, FineBI remains on the startup page, as shown in the following figure.

Solution:

1. Open the phoenix-4.12.0-HBase-1.2-client.jar file with a compression tool, enter the javax folder, and delete the el and servlet files, as shown in the following figure.

2. Restart FineBI.

Adding SQL Datasets

After the successful HBase connection, if you add real-time SQL datasets and create self-service datasets, FineBI does not support field names with lowercase letters and special characters (for example, .) in the database tables. If you need to add fields of the two types, you are advised to use extracted data.

Failed Database Connection Through JDBC

Problem:

The database cannot be connected through JDBC. In this case, the message indicating that the system failed to get locations or ZooKeeper failed to find the corresponding address is displayed.

Solution:

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

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

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

During local connection, you need to configure the hosts file in /etc/hosts and add remote mapping (IP address and Machine name, for example, 192.168.5.206 centos-phoenix).

Database Connection Through SQuirreL

Solution:

Download SQuirreL at https://sourceforge.net/projects/squirrel-sql/?source=typ_redirect by referring to http://phoenix.apache.org/installation.html#SQL_Client. After installing SQuirreL by default, place the phoenix-xxxx-client.jar in %SQuirrel_HOME%/lib. Start SQuirreL first, and add the driver and the alias.

Problem

If you fail to connect the Huawei HBbase database (big data platform) when using the above-mentioned driver, the error message "Unable to find org.apache.hadoop.hbase.ipc.NettyRpcClient” will be displayed, indicating that the NettyipcCilent method cannot be found, as shown in the following figure.

Cause

The current database environment requires additional configuration, Connection using the usual way will result in a configuration file reading exception.

Solution

Adjust the configuration file and the URL connection writing syntax to solve the validation issue and achieve direct database connection.

• Configuration file modification: Write the configuration method used into Hbase-site.xml, and place the XML file into the relevant JAR package.

• URL modification: Change the format of HBase data connection URL to jdbc:phoenix:quorum:port/database:pricinpal:keytabPath. Relevant attributes can be obtained by URL parsing, and the configuration of attributes obtained from the URL will be used preferentially.