v.25.7New Feature

Support _part_granule_offset virtual column

Official CH changelog text
Support _part_granule_offset virtual column in MergeTree-family tables. This column indicates the zero-based index of the granule/mark each row belongs to within its data part. This addresses #79572. #82341 (Amos Bird). #82341 (Amos Bird)
Introduces the _part_granule_offset virtual column for MergeTree-family tables, representing the zero-based index of the granule (mark) each row belongs to within its data part.

Why it matters

This feature enables users to identify the specific granule (or mark) corresponding to each row in MergeTree tables, facilitating more granular data inspection, debugging, and optimization at the storage level.

How to use it

Users can simply query the virtual column <code>_part_granule_offset</code> in their SELECT statements on MergeTree-family tables without any additional configuration. For example:

SELECT <code>_part_granule_offset</code>, * FROM <table_name> LIMIT 10

Related resources

PreviousNext