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