v.25.6New Feature

Add SQL functions to analyse the names

Add SQL functions to analyse the names of MergeTree parts. #80573 (Mikhail Artemenko).
Introduces new SQL functions to analyze the names of MergeTree parts in ClickHouse.

Why it matters

The feature enables users to parse and extract meaningful information from the complex naming structure of MergeTree parts, facilitating better understanding, monitoring, and management of data partitions and their states.

How to use it

Users can invoke the newly added SQL functions in their queries to dissect MergeTree part names and retrieve specific components such as partition ID, range, or mutation information. This helps in diagnostics and custom logic based on part metadata.