CustomSeparatedWithNamesAndTypes
| Input | Output | Alias |
|---|---|---|
| ✔ | ✔ |
Description
Also prints two header rows with column names and types, similar to TabSeparatedWithNamesAndTypes.
Example Usage
Inserting Data
Using the following txt file, named as football.txt:
Configure the custom delimiter settings:
Insert the data:
Reading Data
Configure the custom delimiter settings:
Read data using the CustomSeparatedWithNamesAndTypes format:
The output will be in the configured custom format:
Format Settings
If setting input_format_with_names_use_header is set to 1,
the columns from input data will be mapped to the columns from the table by their names, columns with unknown names will be skipped if setting input_format_skip_unknown_fields is set to 1.
Otherwise, the first row will be skipped.
If setting input_format_with_types_use_header is set to 1,
the types from input data will be compared with the types of the corresponding columns from the table. Otherwise, the second row will be skipped.
