About Smart Load Wizard (Hadoop) | Teradata Studio/Studio Express - About Smart Load Wizard (Hadoop) - 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

The Smart Load Wizard enables you to create Hadoop tables derived from data stored in an external file.

Input File
Enter the path and name for the file to import or click Browse to find a file on your file system.
File Type
This is Delimited Text for Hadoop destinations.
Column Labels in First Row
Select to specify that the first row in the file contains the column labels so that the first row in the file is ignored. This option is not available for Cloudera systems.
Column Delimiter
Specify the column delimiter used in the input file.
Line Separator
The Line Separator options enable you to import files that have only LineFeed (LF), as in Unix and Linux, or only Carriage Return (CR) as in Apple macOS prior to vervsion 10.0, or both, as for Windows. The options are:
  • Windows OS (CR and LF)
  • Prior to Apple macOS 10.0 (CR)
  • Unix, Linux, Apple macOS 10.0 and above (LF)
File Encoding
Specify the type of encoding to used for the file.