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 use where_condition from config with partition_key alias in query for checking partition existence (Earlier it was used only in reading data queries). #6577 (proller)
clickhouse-copier now supports using the where_condition configuration with partition_key aliases when checking for partition existence, not just during data reading queries.

Why it matters

This feature enhances the flexibility and accuracy of partition existence checks during data copying operations by allowing users to utilize where_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 specify where_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.