Dbeaver Hbase

Posted : admin On 1/3/2022

DBeaver EE license is a perpetual license that includes one year or two years of support and maintenance. The standard support gives an access to the internal support system on the site. The standard maintenance gives a possibility to download all new product versions released during the whole maintenance period. 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. HBase permissions are enforced given the end-user, not the Phoenix Query Server’s identity. In some cases, it may be desirable to execute the query as some other user – this is referred to as “impersonation”. This can enable workflows where a trusted user has the. 图形化界面客户端连接phoenix操作hbase 下载客户端软件 DBeaver. 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.

  • HBase Tutorial
  • HBase Resources
Dbeaver Hbase
  • Selected Reading

Dbeaver 连接 Hbase

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 keypersonal dataprofessional 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.

Dbeaver Connect Hbase

Dbeaver Hbase

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.

Dbeaver Kerberos Hbase

Step1: Instantiate HBaseAdmin

Dbeaver Hbase

This class requires the Configuration object as a parameter, therefore initially instantiate the Configuration class and pass this instance to HBaseAdmin.

Dbeaver Hbase

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.

Compile and execute the above program as shown below.

The following should be the output: