question Re: Hive GUI ! in Support Questions

Hive GUI !

mlanciaux — Wed, 18 Nov 2015 21:47:19 GMT

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.

Re: Hive GUI !

bsaini — Wed, 18 Nov 2015 21:47:27 GMT

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

Re: Hive GUI !

nsabharwal — Wed, 18 Nov 2015 21:47:57 GMT

@mlanciaux

DBVisualizer or Squirrel.

Please see this http://community.hortonworks.com/content/kbentry/3043/connecting-to-hive-thrift-server-on-hortonworks-us.html

Re: Hive GUI !

aervits — Wed, 18 Nov 2015 22:08:06 GMT

you can also use Microsoft Visual Studio https://azure.microsoft.com/en-us/updates/updated-visual-studio-tools-for-apache-hive/ and Oracle SQL Developer http://www.oracle.com/technetwork/developer-tools/sql-developer/overview/index-097090.html and

Re: Hive GUI !

nsabharwal — Wed, 18 Nov 2015 22:08:28 GMT

@Artem Ervits @mlanciaux

Sql Developer

Re: Hive GUI !

sluangsay — Wed, 18 Nov 2015 22:18:39 GMT

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 !

bsaini — Wed, 18 Nov 2015 22:24:06 GMT

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

bhopp — Wed, 02 Dec 2015 03:44:43 GMT

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 !

nsabharwal — Wed, 02 Dec 2015 04:28:42 GMT

@Benjamin Hopp removing inside wiki link.

@Mark Herring

Re: Hive GUI !

landon_t_robins — Thu, 10 Dec 2015 02:00:33 GMT

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/

Re: Hive GUI !

peter_jaink — Thu, 11 Feb 2016 02:38:00 GMT

Any one tried with kerbrosed Hive with these tools

Re: Hive GUI !

nsabharwal — Thu, 11 Feb 2016 04:04:40 GMT

@peter jaink dbvisualizer works

Re: Hive GUI !

peter_jaink — Thu, 11 Feb 2016 04:11:12 GMT

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.

Re: Hive GUI !

nsabharwal — Wed, 24 Feb 2016 19:26:38 GMT

@peter jaink https://github.com/cyanfr/dbvis_to_hortonworks_hiveserver2/wiki/How-I-Connected-DBVisualizer-9.2.2-on-Windows-to-Hortonwork-HiveServer2

Re: Hive GUI !

amakey02 — Fri, 22 Apr 2016 23:50:38 GMT

I have used DBVisualizer with kerborized Hive and have no issues

Re: Hive GUI !

ehanson — Mon, 17 Jul 2017 22:30:10 GMT

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/

Re: Hive GUI !

pinr — Thu, 21 Mar 2019 11:29:34 GMT

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

Re: Hive GUI !

MarceloSaiedOK — Mon, 22 Jul 2019 06:35:21 GMT

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