v.18.16New Feature

Added Ability to Omit Partition in ALTER TABLE ... FREEZE Query

Official CH changelog text
Added the ability to omit the partition for the ALTER TABLE ... FREEZE query in order to back up all partitions at once. #3514
Added the ability to omit the partition specification in the ALTER TABLE ... FREEZE query to back up all partitions simultaneously.

Why it matters

This feature simplifies the process of creating backups by allowing users to freeze all partitions of a table in a single command, instead of freezing each partition individually. It enhances usability and efficiency in managing table backups.

How to use it

To back up all partitions of a table, use the ALTER TABLE <table_name> FREEZE command without specifying a partition. For example:

ALTER TABLE <table_name> FREEZE

Related resources

PreviousNext