These settings are autogenerated from source.
allow_special_bool_values_inside_variant
Allows to parse Bool values inside Variant type from special text bool values like “on”, “off”, “enable”, “disable”, etc.
check_conversion_from_numbers_to_enum
Throw an exception during Numbers to Enum conversion if the value does not exist in Enum.
Possible values:
- 0 — Disabled.
- 1 — Enabled.
Example
column_names_for_schema_inference
The list of column names to use in schema inference for formats without column names. The format: ‘column1,column2,column3,…’
Method to write Errors to text output.
insert_distributed_one_random_shard
Enables or disables random shard insertion into a Distributed table when there is no distributed key.
By default, when inserting data into a Distributed table with more than one shard, the ClickHouse server will reject any insertion request if there is no distributed key. When insert_distributed_one_random_shard = 1, insertions are allowed and data is forwarded randomly among all shards.
Possible values:
- 0 — Insertion is rejected if there are multiple shards and no distributed key is given.
- 1 — Insertion is done randomly among all available shards when no distributed key is given.
Allows choosing different output formats of the text representation of interval types.
Possible values:
-
kusto - KQL-style output format.
ClickHouse outputs intervals in KQL format. For example, toIntervalDay(2) would be formatted as 2.00:00:00. Please note that for interval types of varying length (ie. IntervalMonth and IntervalYear) the average number of seconds per interval is taken into account.
-
numeric - Numeric output format.
ClickHouse outputs intervals as their underlying numeric representation. For example, toIntervalDay(2) would be formatted as 2.
See also:
into_outfile_create_parent_directories
Automatically create parent directories when using INTO OUTFILE if they do not already exists.
json_type_escape_dots_in_keys
When enabled, dots in JSON keys will be escaped during parsing.
max_dynamic_subcolumns_in_json_type_parsing
The maximum number of dynamic subcolumns that can be created in every column during parsing of JSON column.
It allows to control the number of dynamic subcolumns during parsing regardless of dynamic parameters specified in the data type.
precise_float_parsing
Use the precise float parsing algorithm, which always returns the closest representable value to the input. When disabled, a faster but less accurate algorithm is used that may differ from the precise result by the least significant bits.
validate_experimental_and_suspicious_types_inside_nested_types
Validate usage of experimental and suspicious types inside nested types like Array/Map/Tuple Last modified on July 22, 2026
