# Delimited format settings

Tab-separated and Hive text delimiters, headers, defaults, and row boundaries.

Use a statement `SETTINGS` clause. Defaults in `system.settings` are read-only;
format settings cannot be persisted with `SET`. Put input settings before
`FORMAT`, because the bytes after the format name are input data.

## hive_text_collection_separator

Type: `Char`

Default value: `\x02`

The byte between outermost Array and Tuple elements or Map entries on output; input uses bracketed values.

Applies to: `hive_text`.

## hive_text_map_separator

Type: `Char`

Default value: `\x03`

The byte between outermost Map keys and values, also used at the next nested level on output.

Applies to: `hive_text`.

## hive_text_row_separator

Type: `Char`

Default value: `\n`

The byte ending each output row; input always reads newline-delimited CSV records.

Applies to: `hive_text`.

## hive_text_separator

Type: `Char`

Default value: `\x01`

The byte between top-level fields when reading and writing, with no output quoting or escaping.

Applies to: `hive_text`.

## hive_text_uneven_rows

Type: `Bool`

Default value: `1`

Give omitted trailing input columns their DEFAULT and skip extra fields; off requires the exact field count.

Applies to: `hive_text`.

## tab_separated_check_types

Type: `Bool`

Default value: `1`

Compare the input types header with the bound target column types; when off, skip that header.

Applies to: `tab_separated_with_names_and_types`.

## tab_separated_crlf

Type: `Bool`

Default value: `0`

End each written row with a carriage return and a line feed instead of a line feed.

Applies to: `tab_separated`, `tab_separated_raw`, `tab_separated_with_names`, `tab_separated_with_names_and_types`.

## tab_separated_detect_header

Type: `Bool`

Default value: `1`

Recognize a raw TSV names header and optional matching types header before reading data.

Applies to: `tab_separated_raw`.

## tab_separated_empty_as_default

Type: `Bool`

Default value: `0`

Give an empty field the column's DEFAULT instead of reading it as empty text.

Applies to: `tab_separated`, `tab_separated_raw`, `tab_separated_with_names`, `tab_separated_with_names_and_types`.

## tab_separated_enum_by_number

Type: `Bool`

Default value: `0`

Read a whole number in an Enum column as the label's number instead of its name.

Applies to: `tab_separated`, `tab_separated_raw`, `tab_separated_with_names`, `tab_separated_with_names_and_types`.

## tab_separated_match_names

Type: `Bool`

Default value: `1`

Match input names to target columns ignoring ASCII case; when off, skip the names header and read in target order.

Applies to: `tab_separated_with_names`, `tab_separated_with_names_and_types`.

## tab_separated_null_text

Type: `String`

Default value: `\N`

The field text that stands for NULL when reading and writing; it cannot contain tabs or line breaks.

Applies to: `tab_separated`, `tab_separated_raw`, `tab_separated_with_names`, `tab_separated_with_names_and_types`.

## tab_separated_read_crlf

Type: `Bool`

Default value: `0`

Accept carriage-return/line-feed endings in raw TSV input, removing the carriage return from each record.

Applies to: `tab_separated_raw`.

## tab_separated_skip_empty_lines

Type: `Bool`

Default value: `0`

Ignore empty lines at the end of raw TSV input; empty lines inside the data remain records.

Applies to: `tab_separated_raw`.

## tab_separated_skip_lines

Type: `UInt64`

Default value: `0`

Ignore this many lines at the start of the input, before any header row.

Applies to: `tab_separated`, `tab_separated_raw`, `tab_separated_with_names`, `tab_separated_with_names_and_types`.

## tab_separated_uneven_rows

Type: `Bool`

Default value: `0`

Accept rows with too few or too many fields: missing fields take the column's DEFAULT and extra fields are dropped.

Applies to: `tab_separated`, `tab_separated_raw`, `tab_separated_with_names`, `tab_separated_with_names_and_types`.