v.20.4Improvement
Check Removed Usage of Date/DateTime Columns from TTL Expressions
Check for usingDateorDateTimecolumn from TTL expressions was removed. #9967 (Vladimir Chebotarev)
Why it matters
Previously, ClickHouse restricted the use ofDate 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 includeDate 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.