16.00 - Loading Table Data from a File (Hadoop) - Teradata Studio

Teradata Studio User Guide

Teradata Studio
March 2017
User Guide
  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. The Load Data Wizard opens.
  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 Mac OS X v10.0 (CR)
    • Unix, Linux, Mac OS X v10.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. When you 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.