Skip to content
ClickHouse Docs
ClickHouse DocsClickHouse Docs

allow_experimental_* MergeTree table settings

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

allow_experimental_replacing_merge_with_cleanup

Experimental feature
Type
Bool
Default
0

Allow experimental CLEANUP merges for ReplacingMergeTree with is_deleted column. When enabled, allows using OPTIMIZE ... FINAL CLEANUP to manually merge all parts in a partition down to a single part and removing any deleted rows.

Also allows enabling such merges to happen automatically in the background with settings min_age_to_force_merge_seconds, min_age_to_force_merge_on_partition_only and enable_replacing_merge_with_cleanup_for_min_age_to_force_merge.

allow_experimental_reverse_key

Type
Bool
Default
0
Version history
VersionDefault valueComment
24.120New setting

Obsolete setting, does nothing.

Experimental feature
Type
Bool
Default
0
Version history
VersionDefault valueComment
26.70New setting

Allow creating text indexes with the experimental support_phrase_search argument which stores token positions to support exact phrase matching.

Navigation