Support Questions

Find answers, ask questions, and share your expertise

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

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

avatar
Master Mentor

avatar
Super Collaborator

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.

avatar

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

avatar
New Contributor

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

avatar
Master Mentor

avatar
Master Mentor

avatar
Expert Contributor

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

avatar
Master Mentor

@Benjamin Hopp removing inside wiki link.

@Mark Herring