v.20.8New Feature

Add ALTER SAMPLE BY statement to modify table sample clause

Official CH changelog text
Add ALTER SAMPLE BY statement that allows to change table sample clause. #13280 (Amos Bird).
Introduces the ALTER SAMPLE BY statement to modify the sampling clause of an existing table.

Why it matters

Allows users to change the sampling key of a table after its creation, enabling more flexible and dynamic management of sampling strategies without requiring table recreation or data reloading.

How to use it

Use the ALTER SAMPLE BY statement followed by the new sampling expression to update the sampling clause of a table. For example:

ALTER TABLE <table_name> SAMPLE BY <expression>

Related resources

PreviousNext