Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

Hive GUI !

SOLVED Go to solution
Highlighted

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

Accepted Solutions

Re: Hive GUI !

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

17 REPLIES 17

Re: Hive GUI !

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

Re: Hive GUI !

Re: Hive GUI !

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.

Re: Hive GUI !

+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.

Re: Hive GUI !

New Contributor

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

Re: Hive GUI !

Re: Hive GUI !

Mentor

Re: Hive GUI !

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.

Re: Hive GUI !

@Benjamin Hopp removing inside wiki link.

@Mark Herring