Using GUI SQL Tools Against Hive on HDP from MacOSX

It is very easy to connect various tools to Hive.

Apache Zeppelin is my favorite tool to query Hive via HiveQL, but you have a ton of options.

First, DBVisualizer, I am using the Free Edition for MacOSx.

For both tools, you will need to copy (or acquire) a copy of two Hive JARS:

hadoop-common.jar

hive-jdbc-1.2.1000.2.4.0.0-169-standalone.jar

On HDP 2.4:

/usr/hdp/current/hive-client/lib/hive-jdbc-1.2.1000.2.4.0.0-169-standalone.jar

/usr/hdp/current/hadoop-client/hadoop-common.jar

Another tool, DBeaver which has a unique twist (it finds and downloads the JARS itself via Maven, though it takes a bit for the initial driver install). It also supports Phoenix, Drill and GemfireXD.

Also I did SquirrelSQL. For SquirrelSQL setup details, check out the official Hive Docs.

jdbc:hive2://localhost:10000/default

org.apache.hive.jdbc.HiveDriver

For Hive URL, see the Hive Docs.

I also connected from SQLWorkBench/J as well. This is a free SQL Tool.