v.18.16New Feature

Added min_time and max_time Columns to system.parts Table

Added the min_time and max_time columns to the system.parts table. These columns are populated when the partitioning key is an expression consisting of DateTime columns. Emmanuel Donin de Rosière
Added min_time and max_time columns to the system.parts table, showing the minimum and maximum DateTime values of the partitioning key expression.

Why it matters

These new columns provide precise intervals for partitions when the partitioning key is an expression containing DateTime columns, helping users better understand the range of data stored in each part.

How to use it

Query the system.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.