v.20.10New Feature

Added formatReadableQuantity function for human-friendly numeric output

Added formatReadableQuantity function. It is useful for reading big numbers by human. #14725 (Artem Hnilov).
Added the formatReadableQuantity function to ClickHouse for formatting large numeric values into a human-readable form.

Why it matters

This feature addresses the need to display big numbers in a more understandable, concise manner for users, making it easier to interpret large quantities without reading raw numeric values.

How to use it

Use the formatReadableQuantity function in your SQL queries to convert large numeric values into a human-readable format. For example:

SELECT formatReadableQuantity(1234567890);