v.22.3Improvement

Ignore TTL in CREATE TABLE AS for unsupported table engines

Official CH changelog text
Ignore per-column TTL in CREATE TABLE AS if new table engine does not support it (i.e. if the engine is not of MergeTree family). #34938 (Azat Khuzhin).
Ignore per-column TTL settings in CREATE TABLE AS statements when the new table engine does not support TTL, specifically if the engine is not part of the MergeTree family.

Why it matters

This feature prevents errors and unintended behavior by automatically disregarding per-column TTL expressions during table creation when using engines that do not support TTL, ensuring smoother table creation workflows and better compatibility across different table engines.

How to use it

When executing CREATE TABLE new_table AS existing_table, ensure the target table engine supports TTL (typically MergeTree family). If it does not, any per-column TTL defined in the source table will be ignored automatically without causing errors.

Related resources

PreviousNext