Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Labels (1)
Super Guru

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

4362-dbvisualizer1.png

4363-dbvisualizer2.png

4364-dbvisualizer3.png

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.

4368-dbeaver1.png

4370-dbeaver3.png

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

jdbc:hive2://localhost:10000/default

org.apache.hive.jdbc.HiveDriver

4371-squirrel1.png

4372-squirrel2.png

For Hive URL, see the Hive Docs.

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

4365-sqlworkbenchj.png

4366-sqlworkbenchj2.png

4367-sqlworkbenchj3.png

9,180 Views
Comments
Super Guru

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.

Super Guru

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

Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
2 of 2
Last update:
‎08-17-2019 12:18 PM
Updated by:
 
Contributors
Top Kudoed Authors