v.19.1New Features

Allow to ALTER Compression Codecs

Allow to ALTER compression codecs. #4054 (alesapin)
Allows users to modify compression codecs of existing table columns using the ALTER command.

Why it matters

This feature enables changing the compression codecs of columns without needing to recreate or reload the table. It helps optimize storage and performance by allowing adjustments to compression settings on existing data, improving flexibility and manageability for users.

How to use it

Use the ALTER TABLE statement to change the compression codec of a specific column. For example:

ALTER TABLE table_name MODIFY COLUMN column_name CODEC(YourNewCompressionCodec);