v.21.9Improvement
Disallow arrayJoin on partition expressions
Disallow arrayJoin on partition expressions. #27648 (Raúl Marín).Why it matters
This feature prevents the use of thearrayJoin function within partition expressions. It addresses potential issues and inconsistencies that can arise when using complex array operations in partitioning, ensuring more predictable partition behavior and query stability.How to use it
The restriction is applied automatically by ClickHouse. Users should avoid usingarrayJoin in their partition key definitions to comply with this rule and ensure their tables are created and queried without errors.