Load Data to a Hadoop Table | Teradata Studio - Loading Data to a Hadoop Table - 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 Data Source Explorer right-click the table and select Data > Load Data.
  2. In the Data Transfer wizard, select Hadoop as the Source Type.
  3. Click Launch.
  4. Do one of the following:
    If you selected this Source Type Complete these steps:
    Teradata
    1. Select the Teradata Connection Profile.
    2. Select the database containing the table you want to load.
    3. Select the table you want to load then click Next.
    4. Specify the column information you want to load, identify if you want to append or replace data in the destination table, specify a Job Name.
    5. [Optional] Click Next to view the SQL generated by the choices you made.
    External File
    1. Click Browse and specify and Input File.
    2. Select the File Type.
    3. [Optional] Select the Column Labels in First Row check box to specify to use the first row of data as the column labels for the new table.
    4. [Optional] Check the Drop Table if Max Error(s) Occur check box if you want to stop the load process if the number of errors you specify occur.
    5. [Optional] Select the Include Null Row box if you want to include null rows in the table.
    6. [Optional] Select the Use System Locale box if you want to use the format displayed.
    7. If you selected the Delimited Text file type:
      1. Select Quick Scan to scan the file partially when trying to derive a table from the imported data.
      2. Complete the fields under File Options.
    8. If you selected an Excel file type, select the Import Worksheet you want to use and specify the row number at which to start loading data in Start Loading At Row Number.
    9. Select the Table Type.
    10. [Optional] To edit the data types of a specific column, click (ellipses) in the column header.
    11. [Optional] Click Next to view the SQL generated by the choices you made.
  5. Click Finish.