Dbeaver is a graphical interface tool designed for integration with a wide variety of databases. Use a graphical interface to manipulate our database and database tables, similar to sqLYog or NavICat.

Download Dbeaver

  • Dbeaver or dbeaver can be downloaded directly from Github
  • Domestic baidu cloud Dbeaver address link: pan.baidu.com/s/19TOxhU8T… Password: d2rc

Common error

Error message: Could not establish the connection to the JDBC: hive2: / / 172.16.250.240:10000 / test: Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=test}) Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=test}) Required field 'client_protocol' is unset! Struct:TOpenSessionReq(client_protocol:null, configuration:{use:database=test})Copy the code

Install dbeaver

Based on the downloaded dbeaver.dmg, double-click to install

Then start the DBeaver graphical interface

Create a Hive connection and configure the host name, port number, and user name

Configuration Change Driver

Download the required driver [hadoop@node03 ~]$CD /opt/module/hive-1.1.0-cdh5.14.2/lib/ [hadoop@node03 lib]$sz Hive - JDBC - 1.1.0 - cdh5.14.2 - standalone. The jarCopy the code

Delete the default driver configuration

Load the downloaded driver configuration

Test the connection

Dbeaver resolved unable to download database driver issue resolved

Dbeaver dedicated to integration with various databases, through Dbeaver we can integration with various databases, different types of database connection the need to download a different drive, drive packages are often abroad, because of the reason of all know that there will be a download slow and unable to download the driver, here to sort out the method to solve the problem of driver download.

Added related configurations to Hive database connections

Click the test connection button, the driver will be downloaded at this time, often at this time the driver is slow or unable to download the problem.

On the Hive connection configuration page, modify driver Settings

Example Change the Maven image used by the driver to The Maven of Ali Cloud Source

alimaven aliyun maven http://maven.aliyun.com/nexus/content/groups/public/ central
Copy the code

Driver download complete, test database link