v.23.5Improvement

System log tables support custom sorting keys

System log tables can now have custom sorting keys. #49778 (helifu).
System log tables in ClickHouse can now be created with custom sorting keys.

Why it matters

This feature addresses the limitation of fixed sorting keys on system log tables, allowing users to optimize query performance and data organization for their specific use cases by defining custom sorting keys.

How to use it

When creating or altering system log tables, users can specify a custom sorting key by using the ORDER BY clause with the desired columns to define the sorting behavior of the log table.