The “tries” option represents the maximum number of unique drillbits to which the client can try to establish a successful connection. The default value is 5. 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. Universal Database Tool Free multi-platform database tool for developers, database administrators, analysts and all people who need to work with databases. Supports all popular databases: MySQL, PostgreSQL, SQLite, Oracle, DB2, SQL Server, Sybase, MS Access, Teradata, Firebird, Apache Hive, Phoenix, Presto, etc. For a recent project I was tasked with configuring DBeaver to connect to Phoenix running in an instance of the CDP Datahub. CDP provides a means of creating a Datahub for running an Operational Database (HBase) and using JDBC via Phoenix to query it. Let's start a Datahub from an Operational Database template. Provision an Operational Database. 云原生数据湖分析（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. How awesome is that?
Bellow are the steps you can use to connect your DBeaver client to a remote database server via SSH.
Note that you only need to do these steps once. The connection configurations will be saved and you can re-use them by right-click + connect.
This guide is created using DBeaver version 6.3.
Method 1: DBeaver via SSH with plain password
1. Create a new connection
Create a new connection by right clicking in your Database Navigator area.
2. Fill SSH details
Fill details under the SSH tab, and click Test tunnel configuration.
Dbeaver Kerberos Hbase
You should see a success message if the details were correct.
3. Fill database’s details
Now that DBeaver can connect via SSH, let’s go back to the General tab and fill in the database credentials:
Clicking Test Connection, you should see a success message. Click Finish.
Method 2: DBeaver with encrypted openssh private key file
If your server requires an openssh private key to login, follow the bellow steps:
1. Add SSHJ to DBeaver
You can do it by opening Help/Install New Software… and typing the following link: https://dbeaver.io/update/sshj/latest/
2. Connect
Use the same steps as Method 1, but adjust as follows:
- On the SSH details menu (step 2), provide the password for your encrypted private key file.
Select SSHJ, under Implementation.
- Change Authentication Method to Public Key.
Select your Private Key
- Click Test tunnel configuration and Finish.
Resources
If you need additional help, this link may be very useful.
- HBase Tutorial
- HBase Resources
- Selected Reading
Creating a Table using HBase Shell
You can create a table using the create command, here you must specify the table name and the Column Family name. The syntax to create a table in HBase shell is shown below.
Example
Given below is a sample schema of a table named emp. It has two column families: “personal data” and “professional data”.
| Row key | personal data | professional data |
|---|
You can create this table in HBase shell as shown below.
And it will give you the following output.
Verification
You can verify whether the table is created using the list command as shown below. Here you can observe the created emp table.
Creating a Table Using java API
You can create a table in HBase using the createTable() method of HBaseAdmin class. This class belongs to the org.apache.hadoop.hbase.client package. Given below are the steps to create a table in HBase using java API.
Step1: Instantiate HBaseAdmin
This class requires the Configuration object as a parameter, therefore initially instantiate the Configuration class and pass this instance to HBaseAdmin.
Step2: Create TableDescriptor
HTableDescriptor is a class that belongs to the org.apache.hadoop.hbase class. This class is like a container of table names and column families.
Step 3: Execute through Admin
Using the createTable() method of HBaseAdmin class, you can execute the created table in Admin mode.
Given below is the complete program to create a table via admin.
Dbeaver 连接 Hbase
Compile and execute the above program as shown below.
Dbeaver Connect Hbase
The following should be the output: