v.20.3New Feature
Add ALTER ... MATERIALIZE TTL Query for Expired Data Removal and Meta-Information Recalculation
Add query ALTER ... MATERIALIZE TTL. It runs mutation that forces to remove expired data by TTL and recalculates meta-information about TTL in all parts. #8775 (Anton Popov)Why it matters
This feature allows users to manually trigger TTL-based data expiration and metadata updates without waiting for the automatic background process. It ensures timely removal of expired data and keeps TTL metadata accurate, improving data freshness and storage management.How to use it
Use theALTER TABLE <table> MATERIALIZE TTL statement to initiate an immediate TTL mutation on the specified table, which removes expired data and updates TTL metadata in all parts.