1. Dbeaver Hbase
2. Dbeaver Connect Hbase

Manage HBase data with visual tools in DBeaver like the query browser. The CData JDBC Driver for HBase implements JDBC standards that enable third-party tools to interoperate, from wizards in IDEs to business intelligence tools. This article shows how to connect to HBase data with wizards in DBeaver and browse data in the DBeaver GUI. The HBase JDBC Driver enables users to connect with live HBase data, directly from any applications that support JDBC connectivity. Rapidly create and deploy powerful Java applications that integrate with Apache HBase columnar databases. 云原生数据湖分析（Data Lake Analytics，DLA）是无服务器（Serverless）化的数据湖分析服务，支持 按需与保留 资源使用，打造最具性价比的数据湖分析平台；提供一站式的数据湖分析与计算服务，支持 ETL、机器学习、流、交互式分析，可以与 OSS、数据库等多种数据源搭配使用。. DBeaver is an awesome SQL client and database management tool. It comes with drivers for the most popular databases, including MySQL, PostgreSQL, SQLite and many others, meaning you can learn one tool and use it across projects built on different technology stacks. Dbeaver dbeaver是一款免费的数据库桌面连接工具，基于Apache-2.0协议开源，支持常见的数据库连接，如MySQL/MariaDB, PostgreSQL, Greenplum, Oracle, DB2 LUW, Exasol, SQL Server, Sybase/SAP ASE, SQLite, Firebird, H2, HSQLDB, Derby, Teradata, Vertica, Netezza, Informix等.对于使用clickhouse的同学来说，dbeaver.

Tested and verified for MS Windows, Linux and Mac OS X.

Install:

Windows installer – run installer executable. It will automatically upgrade version (if needed).
MacOS DMG – just run it and drag-n-drop DBeaver into Applications.
Debian package – run sudo dpkg -i dbeaver-<version>.deb. Then execute “dbeaver &”.
RPM package – run sudo rpm -ivh dbeaver-<version>.rpm. Then execute “dbeaver &”. Note: to upgrade use “-Uvh” parameter.
ZIP archive – extract archive and run “dbeaver” executable. Do not extract archive over previous version (remove previous version before install).

Upgrade – don’t be afraid to remove previous DBeaver version – your settings won’t be lost. All settings are kept in the separate folder (DBeaverData in user home)

Java notes:
DBeaver requires Java 11 or higher. Since version 7.3.1 all distributions include OpenJDK 11 bundle.
If you want to use you own locally installed Java you may delete folder “jre” in the DBeaver installation folder.

Debian repository:

Ubuntu PPA:
You can use PPA repository to easily install/upgrade DBeaver on Debian Linuxes. Mostly it is the same as regular Debian repo but it is hosted on Launchpad.

Early Access:

You may get latest build (EA version) of DBeaver. Usually it contains all major bug fixes found in current stable version. Just choose the archive corresponding to your OS and hardware from the following folder: EA version downloads.

Source code:

Archive:

All recent DBeaver versions are available in the archive.

CloudBeaver

DBeaver is desktop application.
If you are looking for a web-based database management system – please check another of our products: CloudBeaver.

It is also open-source and free.

• Apache Drill Tutorial

• Apache Drill Useful Resources

• Selected Reading

HBase is a distributed column-oriented database built on top of the Hadoop file system. It is a part of the Hadoop ecosystem that provides random real-time read/write access to data in the Hadoop File System. One can store the data in HDFS either directly or through HBase. The following steps are used to query HBase data in Apache Drill.

How to Start Hadoop and HBase?

Step 1: Prerequisites

Before moving on to querying HBase data, you must need to install the following −

• Java installed version 1.7 or greater
• Hadoop
• HBase

Step 2: Enable Storage Plugin

After successful installation navigate to Apache Drill web console and select the storage menu option as shown in the following screenshot.

Then choose HBase Enable option, after that go to the update option and now you will see the response as shown in the following program.

Here the config settings “hbase.zookeeper.property.clientPort” : “2181” indicates ZooKeeper port id. In the embedded mode, it will automatically assign it to the ZooKeeper, but in the distributed mode, you must specify the ZooKeeper port id’s separately. Now, HBase plugin is enabled in Apache Drill.

Step 3: Start Hadoop and HBase

After enabling the plugin, first start your Hadoop server then start HBase.

Creating a Table Using HBase Shell

After Hadoop and HBase has been started, you can start the HBase interactive shell using “hbase shell” command as shown in the following query.

Query

Then you will see the response as shown in the following program.

Result

To query HBase, you should complete the following steps −

Create a Table

Pipe the following commands to the HBase shell to create a “customer” table.

Query

Dbeaver Hbase

Load Data into the Table

Create a simple text file named “hbase-customers.txt” as shown in the following program.

Example

Now, issue the following command in hbase shell to load the data into a table.

Query

Query

Now switch to Apache Drill shell and issue the following command.

Result

The output will be 4 rows selected in 1.211 seconds.

Apache Drill fetches the HBase data as a binary format, which we can convert into readable data using CONVERT_FROM function available in drill. Check and use the following query to get proper data from drill.

Dbeaver Connect Hbase

Query

Result