Created on 07-28-201607:41 AM - edited 08-17-201911:09 AM
TOAD is a freeware tool available for OSX and Windows from Dell. It supports Kerberos, Hive, HDFS Explorer, SQL, export to CSV/XLS, charting and logging. The documentation mentions support for up to HDP 2.3, but I had most features work well and fast with HDP 2.4.2 Sandbox. The tool is very smart to auto detect settings using Ambari.
AMBARI URL for Sandbox: sandbox.hortonworks.com:8080
With Ambari User.
Once configured, you can query Hive Tables through Spark SQL or Hive. The performance is quite good.