Bridge the gap between legacy RDBMS technologies and Hadoop’s advanced analytics capabilities with Toad for Hadoop. Toad for Hadoop simplifies the overall complexity of Hadoop, reducing the learning curve to help you achieve a rapid return on your Hadoop investment. With Toad for Hadoop, you can easily transfer data between Oracle and Hadoop, write Hive queries (SQL on Hadoop) and gain insight into the level of activity and performance of your Hadoop cluster.
Use the full wizard for enterprise Hadoop connectivity to both Hortonworks and Cloudera. Connect to Cloudera VirtualBox VM for quick POC efforts.
Present files and folders that reside in HDFS as tables for easy querying; also, interactively create partitioned or bucketed Hive tables.
Identify and navigate relationships between the Hive table and underlying HDFS files or directories with ease.
Browse, sort and rerun previously executed Spark, Impala and Hive queries; view samples of previously returned datasets for more context.
View auto-completion of Spark, Impala and Hive queries with popup schema; view object metadata interactively on mouse-over.
Set Hadoop properties inline. Assign priority to queries in Hadoop queues by importance to fast track mission-critical queries.
Upload and download files and folders intuitively from HDFS to the OS file system. Browse and view data within HDFS. Use a wizard to create a Hive table statement to present data as a SQL query-able Spark, Impala and Hive table.
Transfer data from Oracle to Hadoop and vice versa. OraOOP integration streamlines migration of data from RDBMS to Hadoop.
Gain a graphical overview of job activity that calls out long-running tasks as well as providing granular detail about map and reduce tasks.
Understand high throughput bottlenecks and resource usage with drilldown log details easily sorted by elapsed time.
NOTE: To ensure full functionality, Toad for Apache Hadoop requires Microsoft Visual C++ 2010 SP1 Redistributable Package (x64) to be installed.
Database platform Versions:
NOTE: The listed versions have been thoroughly tested, but other versions are supported as well. If you encounter any problem while working with them, please let us know on the Toad World forum.
NOTE: Metastore support has been discontinued since Toad for Apache Hadoop 1.1.1.