Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

check_* MergeTree table settings

These settings are available in system.merge_tree_settings and are autogenerated from ClickHouse source.

check_delay_period

Type
UInt64
Default
60

Obsolete setting, does nothing.

check_sample_column_is_correct

Type
Bool
Default
1

Enables the check at table creation, that the data type of a column for s ampling or sampling expression is correct. The data type must be one of unsigned integer types: UInt8, UInt16, UInt32, UInt64.

Possible values:

  • true — The check is enabled.
  • false — The check is disabled at table creation.

Default value: true.

By default, the ClickHouse server checks at table creation the data type of a column for sampling or sampling expression. If you already have tables with incorrect sampling expression and do not want the server to raise an exception during startup, set check_sample_column_is_correct to false.

Navigation