Load Table Data from a File (Hadoop) | Teradata Studio/Studio Express - Loading Table Data from a File (Hadoop) - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Use the Load Data Wizard to load data from an input file into a table using a combination of WebHDFS and JDBC. The input file must be a delimited text file. If the table is not empty, the Load Data Wizard appends or replaces the existing data.
  1. Open the Data Transfer perspective.
  2. Select a Hadoop table in the Data Source Explorer as the destination table.
  3. Right-click the table and select Data > Load Data.
  4. In the Data Transfer Wizard, select External File as the Source Type.
  5. Click Launch.
  6. At Input File, type the directory path and name of the file that contains the data you want to import.
    To find a file in your file system, click Browse, select the file, and click Open.
  7. [Optional] Select Replace Existing Data to specify that data in the source file replaces any existing data in the destination file.
  8. In Line Separator, select one of the following options based on the operating system from which the data is imported. This option enables you to import files with only Carriage Returns (CR), only LineFeeds (LF), or both Carriage Returns and LineFeeds (CR and LF).
    • Windows OS (CR and LF)
    • Prior to Apple macOS 10.0 (CR)
    • Unix, Linux, Apple macOS 10.0 and above (LF)
  9. In File Encoding, select the character set to use to encode the data.
    The options are: UTF-8, UTF-16, ISO-8859-1, UTF-16BE, UTF-16LE, US-ASCB, Cp1252.
    A sample of the input file based on the options you select displays below the File Options. If you change the values selected in File Options fields, the sample row display also changes.
  10. Click Finish.
    A file transfer job is launched in the Transfer Progress View view. When the transfer is complete, it is displayed in the Transfer History View.