v.22.2Improvement

Fixes issues with parallel view processing and view duration for materialized views in ClickHouse

Official CH changelog text
Fixes parallel_view_processing = 0 not working when inserting into a table using VALUES. - Fixes view_duration_ms in the query_views_log not being set correctly for materialized views. #34067 (Raúl Marín).
Fix issues with parallel_view_processing = 0 when inserting into tables using VALUES and correct view_duration_ms in query_views_log for materialized views.

Why it matters

This update resolves two problems: first, it ensures that the parallel_view_processing setting is properly respected (disabled) during INSERT ... VALUES operations; second, it fixes the incorrect recording of materialized view execution time in the view_duration_ms field within the query_views_log. These fixes improve query logging accuracy and control over view processing behavior.

How to use it

Users should set parallel_view_processing = 0 in their session or server settings to disable parallel processing of views during INSERT ... VALUES queries. The view_duration_ms field in query_views_log will now automatically reflect correct timing for materialized views without additional configuration.

Related resources

PreviousNext