To setup a connection with Hive/Hadoop in DbVisualizer to as follows:

  1. Install Apache Hadoop
  2. Install Apache Hive
  3. Setup Hadoop and start it
  4. Open DbVisualizer and the Tools->Driver Manager
  5. Select the Hive driver entry and load the following jar files:
    HIVE_HOME/lib/hive-jdbc-*-standalone.jar
    HADOOP_HOME/share/hadoop/common/hadoop-common-*.jar
  6. When the driver manager has searched the jar files, org.apache.hive.jdbc.HiveDriver will be listed in the Driver Class field
  7. Close the Driver Manager
  8. Open Tools->Connection Wizard to create a new Hive connection and make sure the Hive driver entry is selected in the first pane and that correct Database details are specified in the last pane
  9. Click Finish to create the new Hive database connection and connect it

Hive JDBC setup lists additional information for the Hive driver.


This old external article explains how to connect to Hortonwork HiveServer2 with DbVisualizer 9.2.2:


https://github.com/cyanfr/dbvis_to_hortonworks_hiveserver2/wiki/How-I-Connected-DBVisualizer-9.2.2-on-Windows-to-Hortonwork-HiveServer2