v.20.4Improvement

Check Removed Usage of Date/DateTime Columns from TTL Expressions

Check for using Date or DateTime column from TTL expressions was removed. #9967 (Vladimir Chebotarev)
Removal of restrictions on using Date or DateTime columns in TTL expressions.

Why it matters

Previously, ClickHouse restricted the use of Date or DateTime columns in TTL expressions. This change removes that check, allowing more flexibility in defining TTL rules based on date or datetime columns, which enables users to implement TTL logic directly using these column types.

How to use it

Users can now include Date and DateTime columns in TTL expressions without encountering validation errors. To apply TTL expressions with these columns, define the TTL clause as usual during table creation or alteration, referencing the relevant Date or DateTime columns.