v.21.1New Features
Support SHOW SETTINGS Statement and Clause Enhancements in ClickHouse
SupportSHOW SETTINGSstatement to show parameters in system.settings.SHOW CHANGED SETTINGSandLIKE/ILIKEclause are also supported. #18056 (Jianmei Zhang).
Why it matters
This feature provides users with a convenient SQL command to view current ClickHouse server settings directly, including the ability to filter results or focus only on changed settings. It simplifies configuration management and auditing by integrating settings inspection into familiar SQL syntax.How to use it
Use theSHOW SETTINGS statement to list all parameters from system.settings. To display only settings that have been changed from their defaults, use SHOW CHANGED SETTINGS. You can apply LIKE or ILIKE clauses to filter the output based on setting names.SHOW SETTINGS;
SHOW CHANGED SETTINGS;
SHOW SETTINGS LIKE '%timeout%';
SHOW CHANGED SETTINGS ILIKE 'max_%';