v.1.1.54394New Feature

OPTIMIZE TABLE ... FINAL Now Available for ReplicatedMergeTree Without Partitions

Official CH changelog text
Now OPTIMIZE TABLE ... FINAL can be used without specifying partitions for ReplicatedMergeTree (Amos Bird).
OPTIMIZE TABLE ... FINAL can now be executed without specifying partitions for ReplicatedMergeTree tables.

Why it matters

Previously, users had to specify partition names when running OPTIMIZE TABLE ... FINAL on ReplicatedMergeTree tables. This feature simplifies the optimization process by allowing a full final optimization across all partitions without manual partition specification, reducing user effort and potential errors.

How to use it

Simply run the OPTIMIZE TABLE table_name FINAL command on a ReplicatedMergeTree table without specifying any partitions. ClickHouse will perform the final merges across all partitions automatically.

Related resources

PreviousNext