A tutorial on connecting dbeaver to hive
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.