v.19.17Improvement

Make Range Function Behaviors Almost Like Pythonic One

Official CH changelog text
Make range function behaviors almost like pythonic one. #7518 (sundyli)
The range function behavior has been updated to closely match the Pythonic range function.

Why it matters

This feature improves usability and familiarity by aligning the range function in ClickHouse with Python's version, making it easier for users transitioning from Python and reducing confusion around how ranges are generated.

How to use it

Use the range function as before in SQL queries. The function now behaves similarly to Python's range, supporting start, stop, and step parameters with the expected Pythonic semantics.

Related resources

PreviousNext