Clickhouse: Allow to undo ALTER TABLE ... MODIFY SETTING

Created on 3 Sep 2020  路  2Comments  路  Source: ClickHouse/ClickHouse

I run

ALTER TABLE target_table on CLUSTER '{cluster}' MODIFY SETTING merge_with_ttl_timeout = 3600

But there's no way to undo it. I want the default TTL value to be mirrored for the table so I need to reset this settings.

I can run

ALTER TABLE target_table on CLUSTER '{cluster}' MODIFY SETTING merge_with_ttl_timeout = 86400

but that still would be only static setting and default would not be mirrored.

feature

Most helpful comment

maybe implement something like
ALTER TABLE ... REMOVE SETTINGS
ALTER TABLE ... RESET SETTINGS

All 2 comments

maybe implement something like
ALTER TABLE ... REMOVE SETTINGS
ALTER TABLE ... RESET SETTINGS

Or ALTER TABLE ... MODIFY SETTINGS xxx = DEFAULT

Was this page helpful?
0 / 5 - 0 ratings