v.25.11New Feature
Add support for the cume_dist window
Added support for the cume_dist window function. Fixes #86920. #88102 (Manuel).Why it matters
Thecume_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 thecume_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>