v.24.11Improvement

Vertical Format Enhancements in Pretty Formats

Official CH changelog text
The Vertical format (which is also activated when you end your query with \G) gets the features of Pretty formats, such as: - highlighting thousand groups in numbers; - printing a readable number tip. #71630 (Alexey Milovidov).
The Vertical output format in ClickHouse has been enhanced with features from Pretty formats, including thousand group highlighting in numbers and readable number tips.

Why it matters

This feature improves the readability of query results when using the Vertical format (activated by ending a query with \G), making it easier for users to interpret large numeric values by visually grouping thousands and providing helpful number annotations.

How to use it

To use this enhanced output, simply end your query with \G to activate the Vertical format. The improved formatting features will automatically apply to the query results.

Related resources

PreviousNext