v.25.12New Feature
S3/Azure Queue add setting commit_on_select
In storage S3/Azure Queue add settingcommit_on_select(to define whether processed data needs to be committed and whether to applyafter_processingaction). The default value isfalse, fix check for attached mv during select. #91450 (Kseniia Sumarokova).
Why it matters
This feature addresses the need for explicit control over committing processed data and executing post-processing actions when reading from S3/Azure queue storages. It fixes the handling of attached materialized views duringSELECT and improves data processing correctness and consistency.How to use it
To enable this behavior, set thecommit_on_select setting to true in the table engine configuration for S3 or Azure Queue. By default, this setting is false, meaning processed data is not committed, and after_processing actions are not executed during SELECT.