v.24.4Improvement

Table system.backup_log Now Uses Default Sorting Key event_date, event_time

Official CH changelog text
Table system.backup_log now has the "default" sorting key which is event_date, event_time, the same as for other _log table engines. #62667 (Nikita Mikhaylov).
The system.backup_log table now includes a default sorting key of event_date, event_time, aligning it with other _log table engines in ClickHouse.

Why it matters

This feature standardizes the sorting key of the system.backup_log table, improving consistency with other _log tables. It ensures more efficient querying and organization of backup event data based on the timestamp, enhancing performance and usability.

How to use it

Users can utilize the system.backup_log table as usual without additional configuration. The default sorting key event_date, event_time is automatically applied, benefiting queries that filter or order by these columns.

Related resources

PreviousNext