v.23.8Improvement

Add stderr_reaction Configuration to Manage External Command stderr Handling

Add stderr_reaction configuration/setting to control the reaction (none, log or throw) when external command stderr has data. This helps make debugging external command easier. #43210 (Amos Bird).
Introduces the stderr_reaction setting to control how ClickHouse reacts when external commands write to stderr, allowing users to choose between ignoring, logging, or throwing an error based on stderr output.

Why it matters

This feature improves debugging and error handling for external commands executed by ClickHouse by providing configurable reactions to stderr output. It helps users identify when external commands produce warnings or errors, enhancing observability and control.

How to use it

Users can set the stderr_reaction option to one of the following values: none to ignore stderr output, log to log the stderr messages, or throw to raise an error when stderr receives data. This setting can be configured in the server configuration file or specified per query.