Teradata Plug-in for Eclipse

Downloads
Highlighted
Teradata Employee

Teradata Plug-in for Eclipse

The Teradata Plug-in for Eclipse is based on the Eclipse plug-in framework and Data Tools Platform (DTP). Teradata Plug-in for Eclipse enables Eclipse DTP to operate with the Teradata Database and value-added features.

► NOTE: This version requires Java Runtime Environment 1.7 or 1.8.

NOTE: Mars JEE Eclipse bundle is missing the EMF Client Platform (ECP) 1.5.1 packages. Before installing the Teradata Plug-in, you must:

     -  Install the EMF Client Platform 1.5.1 by going to the Eclipse Help menu, selecting Install New Software... and entering the EMF ECP 1.5.x Update Site (http://download.eclipse.org/ecp/releases/releases_15/).

Note: If you have the previous version of EMF ECP installed, you want to remove it from Eclipse before installing the new version.

To install the new version:

     -  Press the Add... button to add the location of the EMF ECP 1.5.x Update Site (see image below).

     -  Choose this site and install the "ECP SDK 3.x" in the "All SDKs" category. Press Next to install EMF ECP.

     -  Before letting Eclipse restart to finish the installation, remove the file

            plugins\org.eclipse.emf.ecp.view.swt.layout_versionNumber.jar

     - To remove this plugin, locate your Eclipse directory, and delete plugins

               \org.eclipse.emf.ecp.view.swt.layout_<versionNumber>.jar

     -  Restart Eclipse, File>Restart

     -  Install Teradata Plug-in for Eclipse

To install the Teradata Plug-in for Eclipse via the Eclipse Update Site process, bring up Eclipse and run the Software Updates process.

 

  • Select all of the Teradata Plug-in for Eclipse features to install.
  • Click Next to proceed with the installation.

 

To install from a local Teradata Plug-in for Eclipse Update Site, download the zip file locally. Refer to the Installation Guide for further instructions on installing Teradata Plug-in for Eclipse.

Teradata Plug-in for Eclipse contains open source components. A package containing the source code and licenses for these components is also available above for download. This package does not contain proprietary Teradata source code.

For help getting started using the Teradata Plug-in, refer to the Getting Started with Teradata Plug-in for Eclipse article.

Readme

Teradata Plug-in for Eclipse 15.11 release information.

Supported Platforms:

=============================

     Windows Vista  - Microsoft Windows Vista Enterprise, 32-bit and 64-bit

     Windows Server - Microsoft Windows Server 2003, 32-bit and 64-bit

                    - Microsoft Windows Server 2008, 32-bit and 64-bit

     Windows 2000   - Microsoft Windows 2000, 32-bit

     Windows 7      - Microsoft Windows 7, 32-bit and 64-bit

     Windows 8      - Microsoft Windows 8 and 8.1, 32-bit and 64-bit

     Windows 10     - Microsoft Windows 10, 32-bit and 64-bit

     Apple Mac      - OSX 10.7, 10.8, 10.9, 10.10, and 10.11

Dependent Eclipse Software:

=============================

     Eclipse IDE for Java JEE Developers Mars (Eclipse 4.5.2)

     NOTE: Luna and Mars JEE Eclipse bundles are missing the EMF Client Platform (ECP) 1.5.1 packages. You must:

     Before installing the Teradata Plug-in, you must:

     -  Install the EMF Client Platform 1.5.1 by going to the Eclipse Help menu,

        selecting Install New Software... and entering the EMF ECP 1.5.x Update Site.

        (Note that if you have the previous version of EMF ECP installed, you want to remove

        it from Eclipse before installing the new version.)

     To install the new version:

     -  Press the Add... button to add the location of the EMF ECP 1.5.x Update Site.

        (http://download.eclipse.org/ecp/releases/releases_15)

     -  Choose this site and install the "ECP SDK 3.x" in the "All SDKs" category.

        Press Next to install EMF ECP.     

     -  Before letting Eclipse restart to finish the installation, remove the file

            plugins\org.eclipse.emf.ecp.view.swt.layout_versionNumber.jar

     -  To remove this plugin, locate your Eclipse directory, and delete plugins

               \org.eclipse.emf.ecp.view.swt.layout_<versionNumber>.jar

     -  Restart Eclipse, File>Restart

     -  Install Teradata Plug-in for Eclipse

Supported Teradata Databases Versions:

======================================

     Teradata Database 13.10

     Teradata Database 14.00

     Teradata Database 14.10

     Teradata Database 15.00

     Teradata Database 15.10

Supported Aster Databases Versions:

======================================

     Aster Database 6.0

     Aster Database 6.10

     Aster Database 6.20

Required Software:

=============================

     Java Runtime Environment (JRE) version 1.7 or greater

     Mac OSX 10.8 needs JDK 1.7 or 1.8.

Install Instructions;

=============================

     Once the dependent software has been downloaded, Teradata Plug-in for Eclipse can

     be installed and configured. Follow this procedure to install Teradata Plug-in for

     Eclipse 15.11 using the Eclipse Update Site install procedure.

     To install Teradata Plug-in for Eclipse 15.11:

     1. From the main menu, click Help and then click Install New Software….

     2. Click the Add... button.

     3. Type ”Teradata Update Site” in the Name field and the Teradata Plug-in for

       Eclipse update site URL as the Location:

       http://downloads.teradata.com/download/cdn/tools/tdide/tdide-15.11.00.00/update/site.xml

     4. Click OK to add the site.

     5. Select each of the Teradata Plug-in for Eclipse components, and then click Next.

     6. When the Feature License Agreement appears, select I accept the terms in the

        license agreement, and then click Next. A list of features appears with the feature

        version, size, and Eclipse install location.

     7. Verify that the information is correct, and then click Finish to continue the

        installation. A warning message appears regarding unsigned JAR content.

     8. Click OK to continue.

     9. When a message appears asking if you want to restart Eclipse, click Yes.

Support Notes:

====================================

Problem - Object lists displayed in the Data Source Explorer and shown in the wrong sort order.

Resolution - In the eclipse.ini file (located in your install directory), add the following variable to the list of -vmargs

     -Djava.util.Arrays.useLegacyMergeSort=true

Bug Fixes

====================================

The following bugs were fixed in 15.11:

IDE-10529 Teradata Result Set Viewer --> Unhandled event loop exception is thrown when closing the Font dialog

IDE-10543 Teradata --> DECOMPRESS is not displayed as keyword

IDE-10707 Teradata Result Set Viewer --> Unhandled event loop exception is thrown when clicking on row/line numbers after hiding the columns in the Result Set

IDE-12133 Copy Object Wizard --> Unhandled event loop exception is thrown when trying to copy the data into new table after generating the SQL for existing table

IDE-12264 Copy Object Wizard --> ‘Confirm Replace’ message box is displayed when clicking on Next button after resetting the wizard

IDE-12265 Copy Object Wizard --> ‘Select Source by’ field (Drop Down list and Text field) Should be enabled after resetting the wizard

IDE-12266 Copy Object Wizard --> Semicolon(;) should be displayed at end of the SQL Query in the SQL Summary page

IDE-12305 Data Lab View Not Showing Data Lab Groups or Data Labs

IDE-12498 Export data from Teradata to External file 'Launch' Button is disabled in Mac 10.11 machine

IDE-12688 Teradata Studio Hangs when loading 10M rows

IDE-13134 Connecting to system that is down looks like it was successful even though it wasn't

IDE-13789 Data Load failed due to SQL Exceptions

IDE-14097 Teradata Plugin for Eclipse compiled with Luna is not compatible with Mars

IDE-14220 PermSpace, TempSpace, and Spool Space need to be read/stored as Longs

IDE-14481 Performance issue on MacOSx Studio - issue with the 'Result' column of the SQL History

IDE-14565 Studio Express clean workspace and add Aster profile problem

Improvements

====================================

The following improvements were made in 15.11:

IDE-7245 Success message to be displayed when the user creates a table/macro/view/UDF using the Create forms

IDE-9443 Add option for creating a MULTISET table using create table form

IDE-9846 Studio: Provide actions on multiple tables like Teradata Administrator

IDE-10478 Privilege dialog - allow grant 'To Object' to include Database option

IDE-10711 Move Space to include Terabyte option

IDE-12079 Allow user to select multiple tables and get row count information

IDE-12886 Teradata - Create Table --> Provide ISOLATED LOADING option/feature in the New Create Table form

IDE-13210 Create Table --> Display an error message when entered more than 256 characters in the Comment(Table/Column level) field in Create Table form

IDE-13720 The Create Table Journal Table field should be a Combo box rather than a text field

IDE-13880 Routines Body Tab: Content Assist should be enabled by Ctrl + Space regardless of parameter mode

IDE-14349 Allow ability to copy rows from the privileges table

Hadoop Configuration Support:

=============================

Teradata Studio provides an option to transfer data to and from Hadoop systems using its feature called the

Smart Loader for Hadoop. The Smart Loader for Hadoop uses the Teradata Connector for Hadoop (TDCH), which is

installed on the Hadoop node, to provide the data transfer to and from the Hadoop system. Teradata Studio

requires TDCH version 1.4.4. The following are the system requirements of TDCH 1.4.4:

    Supported Teradata Database versions:

        Teradata Database 13.10

        Teradata Database 14.00

        Teradata Database 14.10

        Teradata Database 15.00

    Teradata Database 15.10

    Supported Hortonworks Data Platform (HDP) versions:

        HDP 2.1 (Hadoop 2.4.0, HiveServer2 (HCatalog) 0.13.0)

        HDP 2.1.3 (Hadoop 2.4.0, HiveServer2 (HCatalog) 0.13.1)

        HDP 2.3 (Hadoop 2.7.1, Hive 1.2.1, HBase 1.1.1)

    HDP 2.4 (Hadoop 2.7.1, Hive 1.2.1, HBase 1.1.2)

    Supported Cloudera Hadoop (CDH) versions:

        CDH 5.4 (Hadoop/HDFS 2.6.0, HBase 1.0)

Teradata Connector for Hadoop Setup:

====================================

The TDCH 1.4.1 must be installed and configured on the Hadoop system. Teradata Plugin for Eclipse's Smart Loader

for Hadoop uses Oozie to submit the data transfer workflow on the Hadoop System. Please follow these instructions

to configure the Hadoop System and create the Oozie workflow files.

1) If the script is not already on your Hadoop system, download and install the TDCH (version 1.4.4) onto your Hadoop system.

2) Navigate to the TDCH scripts folder in the TDCH install directory (default location: /usr/lib/tdch/1.4/scripts)

3) Execute the configureOozie.sh script as root user, providing the locations of your Hadoop services.

The usage of the configureOozie.sh script is as follows (this is all a single line):

    Usage: ./configureOozie.sh nn=nameNodeHost [nnHA=fs.default.value] [rm=resourceManagerHost] [oozie=oozieHost] [webhcat=webHCatalogHost] [webhdfs=webHDFSHost]

        [nnPort=nameNodePortNum] [rmPort=resourceManagerPortNum] [ooziePort=ooziePortNum] [webhcatPort=webhcatPortNum] [webhdfsPort=webhdfsPortNum]

        [hiveClientMetastorePort=hiveClientMetastorePortNum] [kerberosRealm=kerberosRealm] [hiveMetaStore=hiveMetaStoreHost]

        [hiveMetaStoreKerberosPrincipal=hiveMetaStoreKerberosPrincipal]

(The parameters are entered on a single line. The parameters surrounded by [ ] are optional. The “[“ and “]” are not part of the command.)

(Note: the Job Tracker in HDP 1.x is now the Resource Manager in HDP 2.x)

    nn - The Name Node host name (required)

    nnHA - If the name node is HA (High Availability), specify the fs.defaultFS value found in core-site.xml

    rm - The Resource Manager host name (uses nn parameter value if omitted)

    oozie - The Oozie host name (uses nn parameter value if omitted)

    webhcat - The WebHCatalog host name (uses nn parameter value if omitted)

    webhdfs - The WebHDFS host name (uses nn parameter value if omitted)

    nnPort - The Name node port number (8020 if omitted)

    rmPort - The Resource Manager port number (8050 if omitted)

    ooziePort - The Oozie port number (11000 if omitted)

    webhcatPort - The WebHCatalog port number (50111 if omitted)

    webhdfsPort - The WebHDFS port number (50070 if omitted)

    hiveClientMetastorePort - The URI port for hive client to connect to metastore server (9083 if omitted)

    kerberosRealm - name of the Kerberos realm

    hiveMetaStore - The Hive Metastore host name (uses nn paarameter value if omitted)

    hiveMetaStoreKerberosPrincipal - The service principal for the metastore thrift server (hive/_HOST if ommitted)

The port numbers are HDP’s defaults. So, if the system being set up has all the services

hosted on a single system on the default ports, only the nn parameter is needed.

The script will exit with an error message if the TDCH is not in its expected location.

Otherwise the script will display a message indicating the parameters values. A sample

message is as follows:

The following is the specification of the Hadoop services used by the Oozie workflows:

{

        "Distribution":"HDP",

        "DistributionVersion":"2.4",

        "TeradataConnectorForHadoopVersion":"1.4.4",

        "WebHCatalog":"hostname",

        "WebHCatalogPort":50111,

        "WebHDFS":"hostname",

        "WebHDFSPort":50070,

        "JobTracker":"hostname",

        "JobTrackerPort":8050,

        "NameNode":"hostname",

        "NameNodePort":8020,

        "NameNodeHA":"fs.defaultFS",

        "NameNodeHAConfigured":true,

        "Oozie":"hostname",

        "OoziePort":11000,

        "HiveClientMetastorePort":9083

        "HiveMetaStoreKerberosPrincipal":"hive/_HOST",

        "KerberosRealm":"",

        "HiveMetaStore":"hostname"

}

** You must also make sure the Teradata IDE/Studio client machine can access the Hadoop system services (hostnames and ports provided to configureOozie script).

Thus, you may need to add the Hadoop services host names and IP addresses to your host file or DNS service.