Toad for Apache Hadoop 1.2.0

(1)

Toad™ for Apache™ Hadoop® 1.2.0

Release Notes

September 16, 2015

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

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

About Toad for Apache Hadoop 1.2.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 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 l Create Hive tables from local files or files stored on HDFS (CSV, TSV) l Analyze your Hadoop Applications using Logs and Charts perspectives

Toad for Apache Hadoop now brings the functionality and ease of use of the Toad Relational Database Management family to NoSQL databases!

Toad for Apache Hadoop 1.2.0 Release Notes 1

(2)

New features

Charts Perspective

l A new perspective has been added - Charts. Charts perspective visualizes queued/running/finished

Applications, allowing users to analyze their performance and resource allocation over time to further

optimize their MapReduce tasks.

l The perspective also categorizes Applications by User, Final Status and Type.

Editor Session View

l The new View displays properties and JARs used for a specific Editor session (an Editor

(3)

Show Sqoop Command

l Sqoop command can be now displayed for any item in Transfer Definition by right-clicking it

and selecting Show Sqoop Command.

Enhancements

The following is a list of enhancements implemented in Toad for Apache Hadoop 1.2.0.

Logs perspective - tracking filter

l When users select Application/Job/Task and move up/down a level, the items in the level

will be filtered to only display those linked to the originally selected item.

Complex data type table transfer

l Tables containing one or more complex data types (e.g. ARRAY, MAP, STRUCT, UNIONTYPE...) can be

now transferred by omitting the complex data type columns.

HDFS file Blocks information

l Information about the number of Blocks a file is divided into as well as the Blocks

(5)

Known issues

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

Description Issue ID

When a file is copied on HDFS, its Replication Factor is forcibly set to 1. 2616 Tables with UNIONTYPE columns cannot be displayed when using Hive versionolder than 0.14. 2390

DROP on table doesn't delete data stored in HDFS in case the table was created by another user. 2088 Hive is not able to run queries against tables starting with an underscore character (e.g. "_

Table").

1706

(CDH5) Delimiting characters in tables are escaped by backslashes when transferred to Hive .

When the data is selected using a query, the backslashes are shown, which should not happen.

1647

Tables cannot be dropped under certain circumstances - DROP TABLE *tablename* will return an error when ANALAYZE TABLE *tablename* has been previously executed. (Workaround: Use

DROP TABLE *schemaname*.*tablename* to drop such tables)

1958

Importing tables with custom types throws an error. 367

Import fails if table name contains non UTF-8 characters. 313 Kerberos session timeouts after approximately 8 hours, which may, for example, result in failed

transfer.

98

Hive JDBC drivers are currently backwards incompatible (e.g. JDBC drivers for CDH 5.3 cannot be used with CDH 5.2 or 5.1).

Workaround: Until the issue is resolved Toad for Apache Hadoop will be bundled with properly

working JDBC drivers for the last 3 versions of Cloudera® Distribution Hadoop®.

N/A

System requirements

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

Hardware requirements

Table 1: Hardware requirements Requirement Details

Processor Pentium IV/x86-64

Memory Minimum 1024 MB

Hard disk space Minimum 1,5 GB

(6)

Software requirements

Table 2: Software requirements

Requirement Details

Operating system Microsoft Windows 7 (64-bit)

Other operating systems are currently being tested.

NOTE:To ensure full functionality, Toad for Apache Hadoop requires Microsoft Visual C++ 2010 SP1

Redistributable Package (x64) to be installed.

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, 5.4 Cloudera® QuickStart VM 4.7, 5.3, 5.4

VirtualBox 5.0 and higher

NOTE:Metastore support has been discontinued since Toad for Apache Hadoop 1.1.1.

Product licensing

Toad for Apache Hadoop 1.2.0 BETA does not require licensing.

The installation of Toad for Apache Hadoop 1.2.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.

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.

(7)

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 Cli 1.2 Apache 2.0 Apache Commons Codec 1.9 Apache 2.0 Apache Commons Collections 3.2 Apache 2.0 Apache Commons Configuration 1.6 Apache 2.0 Apache Commons Dbcp 1.4 Apache 2.0 Apache Commons Httpclient 3.1 Apache 2.0

Apache Commons IO 2.1 Apache 2.0

Apache Commons Lang 2.5 Apache 2.0 Apache Commons Logging 1.1 Apache 2.0 Apache Commons Pool 1.5.4 Apache 2.0 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

(8)

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

Log4j 1.2 Apache 2.0

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

(9)

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.