16.10 - Loading Table Data from a File (Hadoop) - Teradata Studio
Teradata Studio Express User Guide
- Teradata Studio
- June 2017
- User Guide
Open the Data Transfer perspective.
Select a Hadoop table in the Data Source Explorer as the destination table.
Right-click the table and select
In the Data Transfer Wizard, select External File as the Source Type.
The Load Data Wizard opens.
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.
[Optional] Select Replace Existing Data to specify that data in the source file replaces any existing data in the destination file.
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)
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.
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.