v.25.9Improvement

Allow using native numbers in WHERE

Official CH changelog text
Allow using native numbers in WHERE. They are already allowed to be arguments of logical functions. This simplifies filter-push-down and move-to-prewhere optimizations. #86390 (Nikolai Kochetov).
ClickHouse now supports using native numbers directly in the WHERE clause as filter conditions.

Why it matters

This feature simplifies query optimization by allowing native numbers to be directly used in WHERE conditions, improving filter push-down and move-to-prewhere optimizations for better query performance.

How to use it

Simply include native number literals as conditions in the WHERE clause of your queries. For example:
SELECT * FROM table WHERE 1

No additional configuration is required.

Related resources

PreviousNext