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:
On HDP 2.4:
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.
For Hive URL, see the Hive Docs.
I also connected from SQLWorkBench/J as well. This is a free SQL Tool.
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.
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