v.20.3Improvement

System Table Enhancements for Feature Support Information

Official CH changelog text
The table system.table_engines now provides information about feature support (like supports_ttl or supports_sort_order). #8830 (Max Akhmedov)
The system.table_engines table now includes columns indicating feature support for different table engines, such as supports_ttl and supports_sort_order.

Why it matters

This feature provides users with detailed information about which capabilities are supported by each table engine. It helps users to make informed decisions when choosing table engines based on their requirements, by easily querying support for features like TTL or sort order.

How to use it

Users can query the system.table_engines system table to check feature support. For example, use SELECT * FROM system.table_engines WHERE supports_ttl = 1 to find all table engines that support TTL.

Related resources

PreviousNext