hive-jdbc-uber-2.6.5.0-292.jar
DbVisualizer (as of version 9.5.5)
Below is an example configuration using DbVisualizer:
Open the Diver Manager dialog ("Tools" > "Driver Manager...") and hit the "Create a new driver" icon.
Fill in the information as seen below. For the "Driver File Paths" you are pointing to hive-jdbc-uber-x.jar.
jdbc:hive2://:/
Create a new connection ("Database" > "Create Database Connection") and fill out the details based on your cluster as seen below.
Hit the "Connect" button to test the connection. You should see something like the following in the "Connection Message" text area if the connection is successful.
Apache Hive
1.2.1000.2.5.3.0-37
null
null
JetBrains DataGrip (as of version 2016.3)
Below is an example configuration using JetBrains DataGrip:
Under "File" > "Data Sources...", create a new Driver.
jdbc:hive2://{host}:{port}/{database}[;]
Then create a new Project Data Source using the new Driver.
After creating the Project Data Source, test the connection. You should see the following:
1