What is the method of operating hbase through DBeaver connection to Phoenix

This article mainly explains "what is the method of operating hbase through DBeaver connection Phoenix", interested friends may wish to have a look. The method introduced in this paper is simple, fast and practical. Next, let the editor take you to learn "what is the method of operating hbase through DBeaver connecting Phoenix?"

Operate hbase preface through DBeaver connection Phoenix

This paper introduces a common database tool, Dbeaver,DBeaver, which can connect to the database through JDBC and can support almost all database products, including MySQL, PostgreSQL, MariaDB, SQLite, Oracle, Db2, SQL Server, Sybase, MS Access, Teradata, Firebird, Derby and so on. The commercial version can support a variety of NoSQL and big data platforms: MongoDB, InfluxDB, Apache Cassandra, Redis, Apache Hive and so on.

This article uses the software version: Dbeaver6.3.0+MySQL8.0.11+Hive2.1.1+Hbase2.2.4+hadoop2.7.3+jdk1.8.0_65,Dbeaver6.3.0 and MySQL8.0.11 are installed on window10,Hive2.1.1+Hbase2.2.4+hadoop2.7.3+jdk1.8.0_65 and installed on virtual machine Centos7. After the connection is completed, the interface is shown below. Through Dbeaver, you can easily analyze and visualize the data on mysql,hive and hbase.

1.Dbeaver installation

Follow the tutorial to install. Add the following fields to the dbeaver.ini configuration file to start through the local java path.

Connect to Phoenix through DBeaver

Ensure that port 2181 of the hbase server is accessible to the outside world

Click to edit driver settings

Access the address of hbase to get ZooKeeper Base Path / hbase

Add a path to the back

Then select the library

Delete the default and choose the downloaded phoenix client jar package by yourself.

Then click on the test connection.

At this point, I believe you have a deeper understanding of "what is the way to operate hbase through DBeaver connection Phoenix?" you might as well do it in practice. Here is the website, more related content can enter the relevant channels to inquire, follow us, continue to learn!