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.
The tool provides a nice view of Charts and Logs.
You can can also browse HDFS files.
