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.
maybe implement something like
ALTER TABLE ... REMOVE SETTINGS
ALTER TABLE ... RESET SETTINGS
Or ALTER TABLE ... MODIFY SETTINGS xxx = DEFAULT
Most helpful comment
maybe implement something like
ALTER TABLE ... REMOVE SETTINGS
ALTER TABLE ... RESET SETTINGS