v.18.12Improvement

Pretty Formats Limit Column Alignment by Width

Pretty formats now have a limit on column alignment by width. Use the output_format_pretty_max_column_pad_width setting. If a value is wider, it will still be displayed in its entirety, but the other cells in the table will not be too wide. #3003
Adds a limit on column alignment width for Pretty output formats in ClickHouse.

Why it matters

This feature addresses the issue of overly wide columns in Pretty formatted output by capping the alignment width. It ensures that even if a cell contains a very wide value, other cells in the same column will not expand excessively, improving the readability of table outputs.

How to use it

Set the output_format_pretty_max_column_pad_width setting to the desired maximum padding width. Values wider than this limit will still be fully displayed, but other column cells will be padded only up to this width.