Support Questions

Find answers, ask questions, and share your expertise

Hive GUI !

Contributor

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

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

View solution in original post

17 REPLIES 17

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

Expert Contributor

I confirm that DbVisualizer works fine with HiveServer2. We use it quite a lot in one big ETL-Hive project we have.

Take care, the free version has some limitations (for instance, you can't have 2 same tabs opened at the same time) and depending on the usage you have of that tool, you might want the comercial version.

+1. I miss the 'run selected' option in free version. Still a great tool though and also works with kerberos environment or when Knox is being used.

New Contributor

can you share a link with steps to configure db visualizer to connect to hive please?

Mentor

Rising Star

I am a big fan of AquaData Studio. Available here: http://www.aquafold.com/aquadatastudio.html It's not free, but is extremely powerful.

@Benjamin Hopp removing inside wiki link.

@Mark Herring

Contributor

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/

New Contributor

Any one tried with kerbrosed Hive with these tools

@peter jaink dbvisualizer works

New Contributor

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.

Explorer

I have used DBVisualizer with kerborized Hive and have no issues

Contributor

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/

Contributor

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

Take a Tour of the Community
Don't have an account?
Your experience may be limited. Sign in to explore more.