v.19.14New Feature

Added an Ability to Alter Storage Settings

Added an ability to alter storage settings. Syntax: ALTER TABLE <table> MODIFY SETTING <setting> = <value>. #6366 #6669 #6685 (alesapin)
Added the ability to alter storage settings of a table dynamically using a new ALTER TABLE ... MODIFY SETTING syntax.

Why it matters

This feature allows users to change storage-related configuration parameters for existing tables without recreating them. It simplifies managing table behaviors such as compression, merge settings, and other storage optimizations, enhancing flexibility and operational efficiency.

How to use it

Use the following syntax to modify a storage setting for a table:

ALTER TABLE <table> MODIFY SETTING <setting> = <value>

Replace <table> with the target table name, <setting> with the name of the storage setting you want to change, and <value> with the new value.