v.18.14Improvement
New Feature: 'partition_key' Alias in clickhouse-copier WHERE Expressions
In a user-defined WHERE expression inclickhouse-copier, you can now use apartition_keyalias (for additional filtering by source table partition). This is useful if the partitioning scheme changes during copying, but only changes slightly. #3166
Why it matters
This feature addresses scenarios where the partitioning scheme of a table changes slightly during data copying. It allows users to apply additional fine-grained filtering based on the source table's partitions, improving control and efficiency in data migration tasks.How to use it
When defining a customWHERE clause in clickhouse-copier, include the partition_key alias to filter source partitions as needed. This provides an easy way to selectively copy data based on partition values.