Created 11-18-2015 01:47 PM
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.
Created 11-18-2015 01:47 PM
DbVisualizer works best. Its easy to use and freely available. Also SQuirreL client works.
Created 11-18-2015 01:47 PM
DbVisualizer works best. Its easy to use and freely available. Also SQuirreL client works.
Created 11-18-2015 02:08 PM
Created 11-18-2015 02:18 PM
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.
Created 11-18-2015 02:24 PM
+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.
Created 03-21-2019 04:29 AM
can you share a link with steps to configure db visualizer to connect to hive please?
Created 11-18-2015 01:47 PM
DBVisualizer or Squirrel.
Please see this http://community.hortonworks.com/content/kbentry/3043/connecting-to-hive-thrift-server-on-hortonwork...
Created 11-18-2015 02:08 PM
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
Created 12-01-2015 07:44 PM
I am a big fan of AquaData Studio. Available here: http://www.aquafold.com/aquadatastudio.html It's not free, but is extremely powerful.
Created 12-01-2015 08:28 PM
@Benjamin Hopp removing inside wiki link.