Load Hadoop Data to Aster | Teradata Studio - Loading Hadoop Data to Aster - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-20
dita:mapPath
rvy1605890559220.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
  1. In the Data Source Explorer, right-click the Aster schema Tables node and select Aster > Data Transfer.
  2. Click Launch.
  3. Do the following:
    1. Select the Hadoop Connection profile, database, and table, then click Next.
    2. In the Column Specification dialog:
      1. Enter an Aster Table name.
      2. Select check boxes to indicate which columns in the Hadoop table to transfer to the Aster table. By default, the column data type of the Aster table is based on the column data type of the source Hadoop table. Verify the column data type and use the list to select a different data type if needed. You can set the data type for each column in the table.
      3. Enter a Job Name.
      4. [Optional] Click Next to view the SQL generated by the choices you made.
  4. Click Finish.