v.24.8Improvement

New CamelCase Aliases for SQL Window Functions in ClickHouse

Official CH changelog text
The window functions in SQL are traditionally in snake case. ClickHouse uses camelCase, so new aliases denseRank() and percentRank() have been created. These new functions can be called the exact same as the original dense_rank() and percent_rank() functions. Both snake case and camelCase syntaxes remain usable. A new test for each of the functions has been added as well. This closes #67042 . #67334 (Peter Nguyen).
Introduced camelCase aliases denseRank() and percentRank() for existing window functions dense_rank() and percent_rank() in ClickHouse.

Why it matters

To align ClickHouse window function naming with traditional SQL camelCase style while maintaining backward compatibility with existing snake_case functions, enhancing usability and consistency for users.

How to use it

Users can call the new window functions using either camelCase syntax, for example, denseRank() and percentRank(), or continue using the original snake_case versions without any change in functionality.

Related resources

PreviousNext