v.1.1.54378Improvement

Usage of FINAL in SELECT and OPTIMIZE with Single Data Part

Published: November 25, 2025

SELECT ... FINAL and OPTIMIZE ... FINAL can be used even when the table has a single data part.

SELECT ... FINAL and OPTIMIZE ... FINAL operations can now be executed on tables with even a single data part.

Why it matters

This feature removes previous restrictions that required multiple data parts for using FINAL modifiers. It allows users to perform deduplication and final merges on tables regardless of the number of data parts, providing greater flexibility and consistency in query and optimization behavior.

How to use it

Simply run queries with the SELECT ... FINAL syntax or execute OPTIMIZE ... FINAL commands on tables without needing to ensure multiple data parts exist. For example:

SELECT * FROM table_name FINAL;
OPTIMIZE TABLE table_name FINAL;