Community Articles

Find and share helpful community-sourced technical articles.
avatar
Master Guru

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.

6136-toaddetect3.png

6135-toaddetect2.png

6134-toaddetect1.png

6137-toaddetect5.png

6138-toaddetect6.png

Once configured, you can query Hive Tables through Spark SQL or Hive. The performance is quite good.

6141-toadforhadoop4.png

6142-toadforhadoop5.png

6143-toadforhadoop6.png

6145-toadforhadoop7.png

The tool provides a nice view of Charts and Logs.

6139-toadforhadoop1.png

6140-toadforhadoop8.png

You can can also browse HDFS files.

11,590 Views
Comments
avatar
Contributor

@Timothy Spann Were you able to configure TOAD with a kerberized cluster?