Shulou(Shulou.com)06/03 Report--

Dbeaver

Dbeaver is a free and open source (GPL) universal database tool for developers and database administrators.

Ease of use is the main goal of the project, which is a well-designed and developed database management tool. Free, cross-platform, based on open source frameworks and allowing various extensions to be written (plug-ins). It supports any database with a JDBC driver.

Hive

Hive is a set of data warehouse analysis system based on Hadoop, which provides rich SQL query methods to analyze the data stored in Hadoop distributed file system: it can map the structured data file to a database table and provide complete SQL query function; it can convert SQL statements into MapReduce tasks to run, and analyze the required content through its own SQL query. This set of SQL is referred to as Hive SQL for short.

DBeaver download link: https://dbeaver.jkiss.org/download/

Select Windows 64 version

2. DBeaver installation begins. Select next step.

Select installation path

Complete the installation

Step 1: first select the preferences in the window on the dbeaver

Add maven

Some netizens are curious, how did you find this maven? See below for explanation.

First of all, our version of hive is 1.1.0-cdh6.4.9.

Baidu searches maven to enter the address: https://mvnrepository.com/search?q=hive

Select cloudear rel to select the appropriate version of 1.1.0-cdh6.4.9

Next, you will see the download address information of the related library we are looking for.

Org.apache.hive hive-jdbc 1.1.0-cdh6.4.9

Note: this artifact it located at Cloudera Rel repository (https://repository.cloudera.com/content/repositories/releases/)

In the second step, we select the link hive, fill in the relevant information, and then select the edit driver settings.

Delete what comes with the system:

Select to add artifacts, and then fill in the corresponding maven information

The result is as follows: click OK and he will automatically download the relevant dependencies

The download effect is as follows:

The download process may take some time, everyone wait patiently

After the download was completed, an error was reported:

We're still missing something. Hadoop-common is still looking for it in the maven warehouse.

Org.apache.hadoop hadoop-common 2.6.0-cdh6.4.9

Continue to add artifacts download in dbeaver

The next step is to continue downloading, we need to download the hadoop-common dependency

After the download is complete, you can link.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.