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.
- 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.
- Click Launch.
- 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 Apple macOS 10.0 (CR)
- Apple macOS 10.0 and after (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 under the File Options. If you change the values selected in File Options fields, the sample row display also changes.
- 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.