First, install the Dbvisualizer
http://www.dbvis.com/
You can also download the cracked version of the program from the Internet, the version used here is Dbvisualizer 9.1.1
Specific installation steps can be Baidu, or modify the installation directory after the default installation can be
Configure Hive JDBC1 in the Dbvisualizer, create a new hive folder under the Dbvisualizer installation directory JDBC folder
D:\Program FILES\DBVISUALIZER\JDBC
2. Copy the relevant jar package of Hadoop into the new hive folder
Jar Package Location:
(1) Hadoop-2.7.5/share/hadoop/common/hadoop-common-2.7.5.jar
Copy the jar package from the red box in the picture to the new hive folder
(2) hadoop-2.7.5/share/hadoop/common/lib/
Copy the jar package involved in the diagram to the New hive folder
3. Copy the relevant jar package of hive into the new hive folder
Jar Package Location:
(1) Apache-hive-2.3.3-bin/jdbc/lib
Copy the jar package involved in the diagram to the New hive folder
4. Results
5. Configure in Tools/driver Manager
Open Dbvisualizer, the jar package that you just added is loaded
6. Configure in Tool--driver Manager
In the top left corner, click Add
Close window when finished
Click Add Connection Database
Select Driver
Click Finish
Hive Learning Path (v) dbvisualizer configuration connect Hive