v.20.7New Feature

Introduce alter_partition_verbose_result Setting for ALTER TABLE Partition Queries

Official CH changelog text
Introduce setting alter_partition_verbose_result which outputs information about touched parts for some types of ALTER TABLE ... PARTITION ... queries (currently ATTACH and FREEZE). Closes #8076. #13017 (alesapin).
Introduces the setting alter_partition_verbose_result that provides detailed output about the parts affected by certain ALTER TABLE ... PARTITION ... commands, specifically ATTACH and FREEZE operations.

Why it matters

This feature addresses the need for transparency and insight into the internal changes performed during partition-related ALTER TABLE queries. By showing which parts were touched, users can better understand the impact of their commands, aiding in debugging, auditing, and ensuring correctness.

How to use it

Enable the feature by setting alter_partition_verbose_result to 1 (true) before executing relevant ALTER TABLE ... PARTITION ... ATTACH or FREEZE queries. This can be done by running:

SET alter_partition_verbose_result = 1


Then proceed with the desired ALTER TABLE query as usual.

Related resources

PreviousNext