| Delimited text |
Specify the following settings for a delimited text file:
- Leading rows to skip
- Specify the number of rows to use as an offset from the beginning of the file.
- Delimiter
- Specify the character used to separate a data field.
- Quote character
- Specify the character used to enclose a data field.
- Remove quotes
- Select one of the following values to indicate whether quotation characters should be removed from a data field during the bulk load:
- Yes: removes the quotation characters.
- No: retains the quotation characters.
- Ignore blank lines
- Select one of the following values to indicate whether blank lines should be removed from the data during the bulk load:
- Yes: removes the blank lines.
- No: retains the blank lines.
- Empty as null
- Select one of the following values to indicate whether empty data values should be set to null during the bulk load:
- Yes: sets empty data values to null.
- No: leaves data values as empty.
|
| Avro |
Select one of the following values for the Empty as null option to indicate whether empty data values should be set to null during the bulk load:
- Yes: sets empty data values to null.
- No: leaves data values as empty.
|
| JSON |
Select one of the following values for the Empty as null option to indicate whether empty data values should be set to null during the bulk load:
- Yes: sets empty data values to null.
- No: leaves data values as empty.
|
| ORC |
Additional file settings handled by the ORC file. |
| Parquet |
Additional file settings handled by Parquet file. |
| Fixed width |
Specify the following settings for a fixed width file:
- Columns:Width
- Specify the columns and their fixed widths.
- Leading rows to skip
- Specify the number of rows to use as an offset from the beginning of the file.
- Ignore blank lines
- Select one of the following values to indicate whether blank lines should be removed from the data during the bulk load:
- Yes: removes the blank lines.
- No: retains the blank lines.
- Empty as null
- Select one of the following values to indicate whether empty data values should be set to null during the bulk load:
- Yes: sets empty data values to null.
- No: leaves data values as empty.
|