v.20.3Improvement

Added deduplication setting for dependent materialized views

Added a setting deduplicate_blocks_in_dependent_materialized_views. #9070 (urykhy)
Added a new setting deduplicate_blocks_in_dependent_materialized_views to control deduplication behavior in dependent materialized views.

Why it matters

This feature addresses the problem of potential duplicate data blocks when populating dependent materialized views. It helps ensure data consistency and avoids redundant processing by enabling deduplication of blocks within these views.

How to use it

Users can enable or disable deduplication by setting the deduplicate_blocks_in_dependent_materialized_views setting in their ClickHouse configuration or session settings according to their needs.