v.24.5Improvement

Disable Pretty Format Restrictions in Non-TTY Output

Official CH changelog text
Disable pretty format restrictions (output_format_pretty_max_rows/output_format_pretty_max_value_width) when stdout is not TTY. #63942 (Azat Khuzhin).
Disable pretty format restrictions (output_format_pretty_max_rows and output_format_pretty_max_value_width) when the standard output is not a TTY.

Why it matters

This feature removes the limitations on pretty format output size when the output is redirected (i.e., not a terminal), allowing users to get complete query results without truncation in non-interactive environments such as log files or pipelines.

How to use it

The feature works automatically when the output is redirected and is not a TTY. There is no explicit action required by the user to enable it. The restrictions continue to apply when outputting directly to a terminal.

Related resources

PreviousNext