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).
Added the setting update_insert_deduplication_token_in_dependent_materialized_views which allows updating the insert deduplication token with the table identifier during inserts in dependent materialized views.

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 setting update_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.