Using GUI SQL Tools Against Hive on HDP from MacOSX

[#1]

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.

[#2]

Good article. I would like to see which one of these have support for kerberos. Going further how one would connected to kerberized cluster. I find many people struggle with this concept.

[#3]

I will give this a try and I'll post the results.

For Windows and DBVisualizer, there's an article with step by step details. DBVisualizer Windows

For Tableau: http://kb.tableau.com/articles/knowledgebase/connecting-to-hive-server-2-in-secure-mode

For Squirrel SQL: https://community.hortonworks.com/questions/17381/hive-with-dbvisualiser-or-squirrel-sql-client.html