Our Community is getting an upgrade! To get everything ready for the relaunch, we’ll be placing the site in read-only mode starting September 21st.
We really appreciate your understanding while we get things set up behind the scenes. Catch up on all the exciting details about the move here.
Need help or have questions? Drop us a line at [email protected]

Community Articles

Find and share helpful community-sourced technical articles.
Announcements
Share your experience with Cloudera on G2 and get a $25 Amazon Gift card.
Hi, I'm CLEO! Something exciting is coming to the Community. Stay Tuned!
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.

12,451 Views
Comments
avatar

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

Version history
Last update:
‎08-17-2019 11:09 AM
Updated by:
Contributors