Hbase data connection

As an important part of the big data platform, Hbase plays a vital role in data storage. Therefore, the connection of BI to Hbase is also one of the indispensable functions. The method provided by FineBI is to connect to Hbase through Phoenix. This article will introduce how to connect in detail.

Note: Please refer to [Platform] Data Connection for detailed introduction of each setting item of platform data connection.

1) Click the link to drive download, as shown in the figure below:

2) Unzip the downloaded compressed package, find phoenix-4.12.0-HBase-1.2-server.jar (the actual version needs to be found according to the actual Hbase version), put it under hbase/lib, restart Hbase (use the command ./stop-hbase.sh, then ./start-hbase.sh);

Find phoenix-4.12.0-HBase-1.2-client.jar in the same decompression package, put it in the FineBI installation directory FineBI/webapps/WebReport/WEB-INF/lib, and restart FineBI.

Note: The database JAR package is likely to conflict with other Hadoop series JAR packages (Hadoop, Hive, Impala, etc.). If you cannot connect to it, you need to delete the JAR of the conflicting database.

3.1 Download the driver

According to the second chapter of this article, download the driver file and put it in the corresponding location, restart Hbase and FineBI.

3.2 Create a data connection

1) Log into the data decision system as an administrator, click "Manage>Data Connection>Data Connection Management", click "New Data Connection", as shown in the following figure:

Note: If a non-administrator user wants to configure a data connection, the administrator needs to assign the authority to the "Data Connection" under the "Manage". For specific operations, please see: Data Connection Control.

2) Select Hbase under "All", as shown in the figure below:

3.3 Configure the data connection

1) Enter the corresponding data connection information according to the actual situation:

• If you choose Kerberos authentication, you need to fill in "Client Principal" and  "Keytab Key Path", and the URL corresponding to Kerberos authentication. For details, refer to Data Connection Kerberos Authentication, as shown in the following figure:

• If you do not choose kerberos authentication, it will be consistent with other database settings, and you can choose to fill in the advanced setting information (refer to Configure Data Connection for the introduction of related attributes), as shown in the following figure:

2) Click "Test Connection", or click "Click to Connect Database" in the "Pattern", if the connection success prompt box pops up, it means that the database is successfully connected, as shown in the following figure:

After the connection is successful, the pattern will automatically select the default value, as shown in the following figure:

Note: The original intention of the pattern is to make it easier for other functions to read the data in the database, just select the "default value".

3) Click "Save" in the upper right corner.

4.1 FineBI is always on the startup page

Problem phenomenon:

After putting phoenix-4.12.0-HBase-1.2-client.jar into the FineBI installation directory FineBI/webapps/WebReport/WEB-INF/lib, restart FineBI and FineBI is always on the startup page. As shown below:

Solution:

1) Open the phoenix-4.12.0-HBase-1.2-client.jar, enter the javax file, delete the "el" and "servlet" folders, as shown in the following figure:

3) Restart FineBI .

4.2 Add a dataset

After the Hbase data connection is successful, when adding a real-time SQL dataset and creating a self-service dataset, the field name with lowercase and special symbols (such as ".") in the database table are not currently supported. If you need to add such fields, it is recommended to use extracted data.

4.3 JDBC access database cannot be connected

Problem phenomenon:

JDBC can't connect to the database, prompt get locations error or zookeeper can't find the corresponding address.

Solution:

Before connecting, please check whether the corresponding IP of the machine name in /etc/hosts is a LAN IP;

Check whether the machine name setting in/etc/hostname is consistent with that in /etc/hosts;

Check whether the IP + machine name configured in the hosts of the machine where FineBI is located is correct.

When connecting locally, you need to configure the/etc/hosts file and add remote mapping: IP+machine name, for example: 192.168.5.206 centos-phoenix

4.4 Use SQuirrel to connect

Solution:

Refer to http://phoenix.apache.org/installation.html#SQL_Client, download SQuirrel at https://sourceforge.net/projects/squirrel-sql/?source=typ_redirect, after the default installation, install phoenix-xxxx-client. Put the jar under %SQuirrel_HOME%/lib, after starting SQuirrel, add the driver first and then add Alias.