v.25.10New Feature

Add ALTER TABLE REWRITE PARTS

Official CH changelog text
Add ALTER TABLE REWRITE PARTS - rewrites the table parts from scratch, by using all new settings (since some, like use_const_adaptive_granularity, will be applied only for new parts). #87774 (Azat Khuzhin).
Adds the ALTER TABLE REWRITE PARTS command to rewrite table parts from scratch, applying new settings that affect part creation.

Why it matters

This feature solves the problem where certain settings (like use_const_adaptive_granularity) are only applied to new parts. By rewriting parts, users can apply these settings retroactively to existing data parts, ensuring consistent application of configurations across the table.

How to use it

Execute the SQL command ALTER TABLE <table_name> REWRITE PARTS to trigger a full rewrite of all existing parts in the specified table using the current settings.

Related resources

PreviousNext