v.19.14Improvement
Clickhouse-copier: Allow Use Where_condition from Config with Partition_key Alias in Query for Checking Partition Existence (earlier It Was Used Only in Reading Data Queries)
clickhouse-copier: Allow usewhere_conditionfrom config withpartition_keyalias in query for checking partition existence (Earlier it was used only in reading data queries). #6577 (proller)
Why it matters
This feature enhances the flexibility and accuracy of partition existence checks during data copying operations by allowing users to utilizewhere_condition filters that include partition_key aliases. Previously, this functionality was limited to reading data queries, which restricted condition usage in existence checks and could complicate partition management.How to use it
Users can specifywhere_condition expressions that reference partition_key aliases within the clickhouse-copier configuration to filter partitions during existence checks. This is configured the same way as before but now applies both to partition existence verification and data reading stages.