v.20.3Improvement
Added deduplication setting for dependent materialized views
Added a setting deduplicate_blocks_in_dependent_materialized_views. #9070 (urykhy)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 thededuplicate_blocks_in_dependent_materialized_views setting in their ClickHouse configuration or session settings according to their needs.