v.1.1.54390New Feature

OPTIMIZE TABLE ... FINAL Now Usable Without Partition for Non-Replicated MergeTree

Official CH changelog text
Now OPTIMIZE TABLE ... FINAL can be used without specifying the partition for non-replicated variants of MergeTree (Amos Bird).
Support for running OPTIMIZE TABLE ... FINAL without specifying a partition on non-replicated MergeTree table engines.

Why it matters

Previously, users had to specify a partition when using OPTIMIZE TABLE ... FINAL on non-replicated MergeTree tables, which was less convenient. This feature simplifies the process by allowing optimization of the entire table in one command, improving usability and maintenance workflows.

How to use it

Simply run the command:

OPTIMIZE TABLE [table_name] FINAL;


without specifying any partition. This works for non-replicated MergeTree table engines.

Related resources

PreviousNext