Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Feature request: support allow_experimental_replacing_merge_with_cleanup #903

Open
salisbury-espinosa opened this issue Nov 4, 2024 · 1 comment

Comments

@salisbury-espinosa
Copy link
Contributor

salisbury-espinosa commented Nov 4, 2024

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;
@aadant
Copy link
Collaborator

aadant commented Nov 6, 2024

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants