Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

Hive GUI !

avatar
Rising Star

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.

1 ACCEPTED SOLUTION

avatar

DbVisualizer works best. Its easy to use and freely available. Also SQuirreL client works.

View solution in original post

17 REPLIES 17

avatar
Rising Star

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/

avatar
Explorer

Any one tried with kerbrosed Hive with these tools

avatar
Master Mentor

@peter jaink dbvisualizer works

avatar
Explorer

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.

avatar
Contributor

I have used DBVisualizer with kerborized Hive and have no issues

avatar
Rising Star

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/

avatar
Rising Star

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