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

Accepted Solutions

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.

View solution in original post

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