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)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.