v.24.5New Feature

Add TTL Information to system.parts_columns Table

Add TTL information in the system.parts_columns table. #63200 (litlig).
Add TTL information to the system.parts_columns table in ClickHouse.

Why it matters

This feature provides visibility into the TTL (time-to-live) settings of columns at the parts level by including TTL metadata in the system.parts_columns table. It helps users understand and track data expiration policies applied to specific parts and columns, improving manageability and monitoring of TTL configurations.

How to use it

Users can query the system.parts_columns system table to view TTL information related to specific parts and columns without any additional configuration. Simply run SELECT queries on this table to inspect TTL details.