v.23.10New Feature

Add simpler SHOW SETTING statement to ClickHouse

Official CH changelog text
Add statement SHOW SETTING setting_name which is a simpler version of existing statement SHOW SETTINGS. #55979 (Maksim Kita).
SHOW SETTING setting_name statement provides a simpler way to query the value of a specific ClickHouse setting compared to the more verbose SHOW SETTINGS command.

Why it matters

This feature addresses the need for a more concise and user-friendly method to retrieve the current value of an individual server setting, improving ease of use and efficiency for users when inspecting configuration parameters.

How to use it

Users can retrieve the value of a specific setting by executing the command:

SHOW SETTING setting_name


where setting_name is the name of the desired configuration setting.

Related resources

PreviousNext