v.25.11New Feature

Add support for the cume_dist window

Added support for the cume_dist window function. Fixes #86920. #88102 (Manuel).
Added support for the cume_dist window function in ClickHouse.

Why it matters

The cume_dist function calculates the cumulative distribution of a value within a window partition, helping users to understand the relative standing of a row within the dataset. This feature enables analytical queries that require percentile rankings and distribution analysis directly in ClickHouse.

How to use it

Use the cume_dist() function as a window function in your SQL queries along with OVER clause to specify partitioning and ordering. For example:

SELECT
<column_list>,
cume_dist() OVER (PARTITION BY <partition_column> ORDER BY <order_column>) AS cumulative_distribution
FROM <table>