Data Transfer from Hadoop - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
bpb1467322243715.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities

With the Data Transfer Wizard, you can export data from a Hadoop table by right-clicking the table and selecting Data > Export Data. Hadoop displays as the source of the transfer (Source Type = Hadoop). You can select Aster as the destination if you choose.

You can also transfer Hadoop data to an Aster table by right-clicking an Aster schema Tables node in the Data Source Explorer and selecting Aster > Data Transfer. The Data Transfer Wizard opens with Hadoop shown as the source and Aster as the destination.

Another option when transferring Hadoop data to Aster is to drag and drop a Hadoop table object from the Data Source Explorer to the Transfer View window. The Data Transfer Wizard launches and opens the Column Specification dialog to allow you to specify which columns to transfer to the Aster table.

When you transfer all table data in a database by right-clicking the database's Tables node in the Data Source Explorer and selecting Hadoop > Data Transfer > External file, the data transfer is performed using the Teradata SmartLoad utility.