v.24.1New Feature
Added setting to update insert deduplication token in dependent materialized views
Added setting update_insert_deduplication_token_in_dependent_materialized_views. This setting allows to update insert deduplication token with table identifier during insert in dependent materialized views. Closes #59165. #59238 (Maksim Kita).Why it matters
This feature solves the problem of deduplication token conflicts in dependent materialized views during insert operations by uniquely updating the token with the table identifier, ensuring correct deduplication behavior and preventing unintended duplicates.How to use it
Enable the feature by settingupdate_insert_deduplication_token_in_dependent_materialized_views to true in your ClickHouse server configuration or at the session level before performing inserts on tables with dependent materialized views.