v.23.2New Feature

Add 'final' setting to apply FINAL modifier to all tables

Official CH changelog text
Add setting final to implicitly apply the FINAL modifier to every table. #40945 (Arthur Passos).
Add a setting named final that implicitly applies the FINAL modifier to every table query.

Why it matters

This feature allows users to automatically ensure that all queries on tables consider the finalized state of data, effectively applying the FINAL modifier without needing to specify it manually in each query. This simplifies handling of MergeTree tables where the FINAL modifier is necessary to get deduplicated and fully merged data.

How to use it

Enable the setting final in your session or user configuration to implicitly apply the FINAL modifier to all table queries. For example, use SET final = 1 before running your queries.

Related resources

PreviousNext