Hive GUI !

[#1]

Hello,

I have a customer wondering what can they use as Hive GUI (but not based on web technology, so not Ambari view or Hue)

I was thinking of / found http://squirrel-sql.sourceforge.net/ and https://www.toadworld.com/products/toad-for-hadoop and probably eclipse with JDBC ? Any feedback is welcome.

Thanks and kind regards.

[#2]

SQuirreL is quite good, and free. Built in Java, and works well with Hive/Beeline. We've overall had success with:

• Teradata Studio
• Squirrel
• Aquadata Studio

http://squirrel-sql.sourceforge.net/

[#3]

Any one tried with kerbrosed Hive with these tools

[#4]

@peter jaink dbvisualizer works

[#5]

I am trying to connect using dbvisualizer it always throws error message saying illegal hadoop version my hdp is 2.6.x and hive is 0.14 , i have all the jar files coming from my unix installation box.

[#6]

@peter jaink https://github.com/cyanfr/dbvis_to_hortonworks_hiveserver2/wiki/How-I-Connected-DBVisualizer-9.2.2-o...

[#7]

I have used DBVisualizer with kerborized Hive and have no issues

[#8]

I like to use SQL Workbench/J. We use this tool for querying Amazon Redshift and Phoenix also. It's free and I haven't had any problems with it. I tried SQuirreL, but it was finicky and didn't like it much. Haven't tried DBVisualizer.

http://www.sql-workbench.net/

[#9]

Hi

i shared toad for hadoop at http://acnalert.eastus.cloudapp.azure.com/world/

i recommend to use the version 1.3 since 1.5 has a limit of licence