About Teradata to Hadoop Column Specification - Teradata Studio

Teradata Studio IDE Plug-in User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
xjy1467322272664.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2043
lifecycle
previous
Product Category
Teradata Tools and Utilities
The Column Specification dialog of the Transfer Teradata Table to Hadoop Table Wizard enables you to set the name of a new Hadoop table and to specify which Teradata table columns to transfer to the Hadoop table. You can view and assign mappings for the table column types. You can also set the job name for the transfer operation.


Source for Data Transfer
Displays the name of the Teradata Database and table database.table that are the source for the data transfer. This information cannot be edited.
Destination for Data Transfer
Provides the name of the Hadoop database to which the data is to be transferred. The table you selected in the previous wizard screen displays as the Hadoop table name. You can change this table selection if you choose.

If you selected to create a new Hadoop table, the Teradata source table name is used as the default name.

File Specifications
Specifies the destination file type and the delimiter to use when transferring the data.
Columns To Transfer
Selects the columns in the Teradata table to transfer to the Hadoop table. By default the column type of the Hadoop table is based on the column type of the source Teradata table. Verify the column data type and use the list to select a different data type if needed. You are able to set the data type for each column in the table. You can also select all columns or no columns to transfer by clicking buttons at the bottom of the list.
Transfer Job
Names the transfer job displayed at the bottom of the screen. You can change the job name. The job name can be useful if the export is an operation that you might re-execute in the future.
Reset All Values
Sets all the fields back to their default values.

When you click Finish, the wizard closes and the settings are passed to the Transfer Progress View where you can monitor the status of the transfer job.