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), only Carriage Return (CR), or both Carriage Returns and LineFeeds (CR and LF). The options are:
- Windows OS (CR and LF)
- Prior to Apple macOS 10.0 (CR)
- Apple macOS 10.0 and after (LF)
- File Encoding
- Specify the type of encoding to used for the file.