v.18.16New Feature
Added min_time and max_time Columns to system.parts Table
Added themin_timeandmax_timecolumns to thesystem.partstable. These columns are populated when the partitioning key is an expression consisting ofDateTimecolumns. Emmanuel Donin de Rosière
Why it matters
These new columns provide precise intervals for partitions when the partitioning key is an expression containingDateTime columns, helping users better understand the range of data stored in each part.How to use it
Query thesystem.parts table to access the min_time and max_time columns directly. This is automatically populated for partitions where the partition key expression includes DateTime columns; no additional configuration is needed.