Other format settings

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

CREATE TABLE tab (
  val Enum('first' = 1, 'second' = 2, 'third' = 3)
) ENGINE = Memory;

INSERT INTO tab SETTINGS check_conversion_from_numbers_to_enum = 1 VALUES (4); -- returns an error

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,…’

errors_output_format

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.

interval_output_format

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.

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

SQL Reference

Data Types

Engines

Functions

Formats

Settings

System Tables

Data Lakes

allow_special_bool_values_inside_variant

check_conversion_from_numbers_to_enum

column_names_for_schema_inference

errors_output_format

insert_distributed_one_random_shard

interval_output_format

into_outfile_create_parent_directories

json_type_escape_dots_in_keys

max_dynamic_subcolumns_in_json_type_parsing

precise_float_parsing

validate_experimental_and_suspicious_types_inside_nested_types

​allow_special_bool_values_inside_variant

​check_conversion_from_numbers_to_enum

​column_names_for_schema_inference

​errors_output_format

​insert_distributed_one_random_shard

​interval_output_format

​into_outfile_create_parent_directories

​json_type_escape_dots_in_keys

​max_dynamic_subcolumns_in_json_type_parsing

​precise_float_parsing

​validate_experimental_and_suspicious_types_inside_nested_types

allow_special_bool_values_inside_variant

check_conversion_from_numbers_to_enum

column_names_for_schema_inference

errors_output_format

insert_distributed_one_random_shard

interval_output_format

into_outfile_create_parent_directories

json_type_escape_dots_in_keys

max_dynamic_subcolumns_in_json_type_parsing

precise_float_parsing

validate_experimental_and_suspicious_types_inside_nested_types