16.00 - Data Transfer from Hadoop - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K

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). Possible destination include Aster, Teradata, or External File.

Another option when transferring Hadoop data 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.

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 FastExport utility.