v.20.4Improvement

Added Support for MATERIALIZE TTL IN PARTITION

Added support of MATERIALIZE TTL IN PARTITION. #9581 (Vladimir Chebotarev)
Added support for the MATERIALIZE TTL IN PARTITION command in ClickHouse.

Why it matters

This feature allows users to manually trigger the materialization of TTL (Time To Live) expressions within specific partitions. It provides better control over TTL data lifecycle management by enabling users to apply TTL rules immediately instead of waiting for the automatic background process.

How to use it

Users can execute the MATERIALIZE TTL IN PARTITION SQL command specifying the target partition to force materializing TTL expressions within that partition. For example:

MATERIALIZE TTL IN PARTITION 'partition_id' FROM table_name