clickhouse-sink-connector
clickhouse-sink-connector copied to clipboard
Feature request: support `allow_experimental_replacing_merge_with_cleanup`
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 you can set this as a merge_tree settings in the server config as a workaround.