v.23.4Improvement

Support for additional_table_filters and additional_result_filter in new planner with documentation update

Support additional_table_filters and additional_result_filter settings in the new planner. Also, add a documentation entry for additional_result_filter. #48405 (Dmitry Novik).
Support for additional_table_filters and additional_result_filter settings has been added to the new query planner in ClickHouse, along with documentation for additional_result_filter.

Why it matters

This feature enables users to apply extra filtering conditions at both the table scan and query result stages within the new planner. It enhances query flexibility and control, allowing more precise data filtering during execution.

How to use it

Users can enable these filters by setting the additional_table_filters and/or additional_result_filter settings in their queries or server configuration. These settings allow specifying additional WHERE-like conditions that are applied during query processing using the new planner.