Skip to main content
Skip to main content
Edit this page

CustomSeparatedWithNames

InputOutputAlias
✔✔

Description​

Also prints the header row with column names, similar to TabSeparatedWithNames.

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 CustomSeparatedWithNames format:

The output will be in the configured custom format:

Format Settings​

note

If setting input_format_with_names_use_header is set to 1, the columns from the 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.