New SQL features in ClickHouse 25.10
Mark Needham
A quick, example-driven look at three SQL additions in ClickHouse 25.10: a NULL-aware comparator, end-of-result pagination that keeps ordering intact, and a shorter way to limit rows per group.
IS NOT DISTINCT FROMfor clear TRUE/FALSE results whenNULLs appear- Negative
LIMITandOFFSETto pull the last N rows and browse backwards, still in ascending order (property sales example) SQL-25.10-Take1 LIMIT … BY ALLto de-duplicate repeated combos with a single keyword
Release blog - https://clickhouse.com/blog/clickhouse-release-25-10
Open House
Scaling ClickHouse to petabytes of logs at OpenAI
Open House
How ClickHouse helps Anthropic scale observability
Open House, User stories
How Capital One cut infrastructure costs by 50%
Engineering leaders at Capital One share how they cut infrastructure costs by 50% and reduced average dashboard load time from 5+ to under 500ms with ClickHouse Cloud.
