Community Articles
Find and share helpful community-sourced technical articles
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.
Super 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.

7,959 Views
Comments
New Contributor

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

Don't have an account?
Coming from Hortonworks? Activate your account here
Version history
Revision #:
2 of 2
Last update:
‎08-17-2019 11:09 AM
Updated by:
 
Contributors
Top Kudoed Authors