clickhouse-sink-connector icon indicating copy to clipboard operation
clickhouse-sink-connector copied to clipboard

Feature request: support `allow_experimental_replacing_merge_with_cleanup`

Open salisbury-espinosa opened this issue 1 year ago • 1 comments

https://clickhouse.com/docs/en/engines/table-engines/mergetree-family/replacingmergetree

The row is deleted only when OPTIMIZE ... FINAL CLEANUP. This CLEANUP special keyword is not allowed by default unless allow_experimental_replacing_merge_with_cleanup MergeTree setting is enabled.

now it works only when changing settings manually

ALTER TABLE test MODIFY SETTING allow_experimental_replacing_merge_with_cleanup = 1;

salisbury-espinosa avatar Nov 04 '24 05:11 salisbury-espinosa

@salisbury-espinosa you can set this as a merge_tree settings in the server config as a workaround.

aadant avatar Nov 06 '24 00:11 aadant