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 Slingshot cut infrastructure costs by 50%
Engineering leaders at Capital One Slingshot share how they cut infrastructure costs by 50% and reduced average dashboard load time from 5+ to under 500ms with ClickHouse Cloud.
Follow us
