v.23.3Improvement

Allow Ignoring Errors When Pushing to MATERIALIZED VIEW with New Setting

Official CH changelog text
Allow errors to be ignored while pushing to MATERIALIZED VIEW (add new setting materialized_views_ignore_errors, by default to false, but it is set to true for flushing logs to system.*_log tables unconditionally). #46658 (Azat Khuzhin).
Added a new setting materialized_views_ignore_errors that allows ignoring errors occurring during data insertion into MATERIALIZED VIEWs.

Why it matters

This feature enables uninterrupted data flushing to MATERIALIZED VIEWs by optionally ignoring errors, which is especially useful for system log tables (system.*_log) where error tolerance is critical to prevent data loss or pipeline interruption.

How to use it

Set the materialized_views_ignore_errors setting to true to ignore errors when pushing data to MATERIALIZED VIEWs. By default, this setting is false. For example, to enable error ignoring for a session or query, use:

SET materialized_views_ignore_errors = 1;


Note that this setting is automatically enabled for flushing logs to system.*_log tables.

Related resources

PreviousNext