v.21.9New Feature

Client Receives Server Warning Information with New system.warnings Table

Official CH changelog text
When client connects to server, it receives information about all warnings that are already were collected by server. (It can be disabled by using option --no-warnings). Add system.warnings table to collect warnings about server configuration. #26246 (Filatenkov Artur). #26282 (Filatenkov Artur).
ClickHouse now provides a system.warnings table that collects and exposes warnings related to server configuration. Additionally, when a client connects to the server, it receives information about all warnings accumulated by the server, which can be optionally disabled.

Why it matters

This feature helps users and administrators to easily monitor and diagnose server configuration issues by having a centralized view of all warnings. Automatically delivering this warning information upon client connection enhances awareness and troubleshooting efficiency.

How to use it

To see server warnings, query the system.warnings table using a statement like SELECT * FROM system.warnings. The automatic delivery of warnings at client connection is enabled by default and can be disabled by starting the client with the --no-warnings option.

Related resources

PreviousNext