Toad for Apache Hadoop 1.1.0

(1)

Toad™ for Apache™ Hadoop® 1.1.0

Release Notes

January 23, 2015

These release notes provide information about the Toad™ for Apache™ Hadoop® release. About Toad for Apache Hadoop 1.1.0

New features Enhancements Known issues System requirements Product licensing Globalization About Dell

About Toad for Apache Hadoop 1.1.0

Toad for Apache Hadoop provides you with an intuitive Windows based interface that allows you to interact with and manage your Hadoop ecosystems regardless of your skill level. With Toad for Apache Hadoop you can:

l Easily connect to your Cloudera® Distribution Hadoop® as well as to Cloudera® QuickStart VM. l Transfer your data from relational database to Hive.

l Use the HiveQL Editor to execute queries against your data stored in Hive. l Store query results for further analysis.

l Organize and download/upload files and folders stored on HDFS.

(2)

Perspectives system

l The application is now divided into Perspectives - Hive, HDFS, Jobs and Transfer.

l It is also possible to connect to your ecosystem even when not all of the perspectives are configured.

Note that you can only work with configured perspectives.

The previous version of Toad for Apache Hadoop grouped everything into one tree in Data Explorer window. Working with multiple perspectives at once wasn't as easy as it could be, since having many items in one perspective would force users to scroll too much. In current version users switch between perspectives and each perspective has the same amount of space and its own UI elements (Table viewers in Hive, File viewers in HDFS...).

UI redesign

l All stored ecosystems and ecosystems actions can be now found under Ecosystem button on Main

(3)

l Active ecosystem is now configured by clicking the Services button on Main Toolbar. An icon next to

the button indicates status of active perspective.

l Connections have been moved to Preferences (Ecosystem button on Main Toolbar | Configure

Ecosystems | Connections).

Cloudera® QuickStart VM support

(4)

The QuickStart VM is a great way to get started with Hadoop® and the current version of Toad for Apache Hadoop makes this even easier. The auto-configuration method sets up everything automatically and requires only little user interaction.

Multiple instances support

l You can now open multiple instances of Toad for Apache Hadoop.

l Each instance can be connected to one Hadoop ecosystem only, two instances cannot be connected to

the same ecosystem.

Previous version was designed so it would be possible to manage multiple Hadoop ecosystems from one instance of Toad for Apache Hadoop. However, working with more than one ecosystem often lead to confusion, since all items from all ecosystems were located in one tree. In this version, each instance of application can manage exactly one ecosystem, which results in clean and productive user interface.

Multiple transfer support

(5)

Ecosystem windows state persist

l The state of opened windows (editors, viewers...) is now saved when you deactivate an ecosystem and

restored when you activate it again. See also:

l Enhancements l Known Issues

Enhancements

The following is a list of enhancements implemented in Toad for Apache Hadoop 1.1.0. Add new Ecosystem wizard

l Hive is now automatically detected when adding a new ecosystem using Cloudera Manager or Servlet.

Jobs tracking

l All information about running, completed and failed jobs is now available in the Jobs perspective,

including logs. Hive Table Viewer

l Additional tab added to Table Viewer - Metadata.

l Data sample is no longer limited to 1000 rows. Additional rows of data are loaded gradually and their

number is not limited. Hive/HDFS/Transfer explorer

l You can now work with multiple items at once (delete/open).

Transfer

l Overwriting tables in target using transfer is now possible (a warning dialog is displayed).

Known issues

The following is a list of issues, including those attributed to third-party products, known to exist at the time of release.

(6)

System requirements

Before installing Toad for Apache Hadoop 1.1.0, ensure that your system meets the following minimum hardware and software requirements.

Hardware requirements

Requirement Details

Processor Pentuim IV/x86-64

Memory Minimum 1024 MB

Hard disk space Minimum 400 MB

Software requirements

Requirement Details

Operating system Microsoft Windows 7 (64-bit)

Other operating systems are currently being tested.

Database and Hadoop distributions support

Distribution/Database Details

Oracle® 10g, 11g R1, 11g R2, 12c Cloudera® Distribution Hadoop® 4.7, 5.1, 5.2, 5.3 Cloudera® QuickStart VM 4.7, 5.1, 5.2, 5.3

Product licensing

Toad for Apache Hadoop 1.1.0 BETA does not require licensing.

The installation of Toad for Apache Hadoop 1.1.0 BETA expires 365 days after first launch.

Globalization

This section contains information about installing and operating this product in non-English configurations, such as those needed by customers outside of North America. This section does not replace the materials about supported platforms and configurations found elsewhere in the product documentation.

(7)

This release is Unicode-enabled and supports any character set. In this release, all product components should be configured to use the same or compatible character encodings and should be installed to use the same locale and regional options. This release is targeted to support operations in the following regions: North America, Western Europe and Latin America, Central and Eastern Europe, Far-East Asia, Japan.

About Dell

Dell listens to customers and delivers worldwide innovative technology, business solutions and services they trust and value. For more information, visitwww.software.dell.com.

Contacting Dell

Technical support:

Online support

Product questions and sales:

(800) 306-9329

Email:

[email protected]

Third-party contributions

This product contains the third-party components listed below. For third-party license information, go to

http://software.dell.com/legal/license-agreements.aspx. Source code for components marked with an asterisk (*) is available athttp://opensource.dell.com.

Component License

ANTLR 3.4 BSD-style license

Apache Commons Codec 1.9 Apache 2.0 Apache Commons Collections 3.2 Apache 2.0 Apache Commons Configuration 1.6 Apache 2.0

(8)

Apache HttpComponents HttpClient 4.2.3 Apache 2.0 Apache HttpComponents HttpCore 4.3 Apache 2.0

Apache POI 3.10 Apache 2.0

Apache XMLBeans 2.6 Apache 2.0

Avro 1.7 Apache 2.0

Bouncy Castle 1.47 BouncyCastle 1

Datanucleus 2.0.3 Apache 2.0 Datanucleus 3.2.1 Apache 2.0 Datanucleus 3.2.10 Apache 2.0 Datanucleus 3.2.2 Apache 2.0 Datanucleus 3.2.9 Apache 2.0 Derby 10.6.1 Apache 2.0

Eclipse RCP 4.4.1 Eclipse Public License 1.0 guava-libraries 11.0.2 Apache 2.0 Hadoop 1.2.1 Apache 2.0 Hadoop CDH4 Apache 2.0 Hadoop CDH5 Apache 2.0 Hive 0.11 Apache 2.0 Hive 0.13 Apache 2.0 Hive CDH4 0.10 Apache 2.0 Hive CDH5 0.12 Apache 2.0 Jackson 1.5.2 Apache 2.0 Jackson 1.8.8 Apache 2.0 Jackson 2.3.1 Apache 2.0

Java 1.8.0 Java Binary Code License

Jersey 1.18 Common Development and Distribution (CDDL) 1.1

JDO 2.3 Apache 2.0

JDO 3.0 Apache 2.0

JLine 0.9.94 BSD 3-Clause License N/A

json-simple 1.1 Apache 2.0

libfb303 0.9 Apache 2.0

(9)

MySQL Connector/J 5.1 MySQL

ojdbc 11 OTN Development and Distribution Lici 01/24/09 01/24/09

PostgreSQL 9.3 1102 JDBC41 9.3 1102 BSD - PostgreSQL 1.0

Protobuf 2.4 BSD 3-Clause License

Protobuf 2.5 BSD 3-Clause License

slf4j - Simple Logging Facade for Java 1.7 slf4j license N/A

Sqoop 1.3 Apache 2.0

Sqoop 1.4.1 Apache 2.0

Sqoop 1.4.4 Apache 2.0

Sqoop CDH4 1.4.3 Apache 2.0

Sqoop CDH5 1.4.4 Apache 2.0

SSHBlackbox Client 10 Secure Black Box 5

virtualbox-sdk 4.3 LGPL (GNU Lesser General Public License) 2.1

(10)

This guide contains proprietary information protected by copyright. The software described in this guide is furnished under a software license or nondisclosure agreement. This software may be used or copied only in accordance with the terms of the applicable agreement. No part of this guide may be reproduced or

transmitted in any form or by any means, electronic or mechanical, including photocopying and recording for any purpose other than the purchaser’s personal use without the written permission of Dell Inc.

The information in this document is provided in connection with Dell products. No license, express or implied, by estoppel or otherwise, to any intellectual property right is granted by this document or in connection with the sale of Dell products. EXCEPT AS SET FORTH IN THE TERMS AND CONDITIONS AS SPECIFIED IN THE LICENSE AGREEMENT FOR THIS PRODUCT, DELL ASSUMES NO LIABILITY WHATSOEVER AND DISCLAIMS ANY EXPRESS, IMPLIED OR STATUTORY WARRANTY RELATING TO ITS PRODUCTS INCLUDING, BUT NOT LIMITED TO, THE IMPLIED

WARRANTY OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NON-INFRINGEMENT. IN NO EVENT SHALL DELL BE LIABLE FOR ANY DIRECT, INDIRECT, CONSEQUENTIAL, PUNITIVE, SPECIAL OR INCIDENTAL DAMAGES (INCLUDING, WITHOUT LIMITATION, DAMAGES FOR LOSS OF PROFITS, BUSINESS INTERRUPTION OR LOSS OF INFORMATION) ARISING OUT OF THE USE OR INABILITY TO USE THIS DOCUMENT, EVEN IF DELL HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. Dell makes no representations or warranties with respect to the accuracy or completeness of the contents of this document and reserves the right to make changes to specifications and product descriptions at any time without notice. Dell does not make any commitment to update the information contained in this document.

If you have any questions regarding your potential use of this material, contact: Dell Inc.

Attn: LEGAL Dept 5 Polaris Way Aliso Viejo, CA 92656

Refer to our Web site (software.dell.com) for regional and international office information.

Trademarks

Dell, the Dell logo, Toad™, T.O.A.D., Toad™ World and any other marks contained in this document here are trademarks of Dell Inc. and/or its affiliates. Other trademarks and trade names may be used in this document to refer to either the entities claiming the marks and names or their products. Dell disclaims any proprietary interest in the marks and names of others.

Legend

CAUTION:A CAUTION icon indicates potential damage to hardware or loss of data if instructions are not followed.

WARNING:A WARNING icon indicates a potential for property damage, personal injury, or death.