ClickHouse release 26.10

ClickHouse 26.10 delivers 104 new features, 225 performance optimizations, and 739 bug fixes, with enhancements aimed at SQL readability, interoperability, query flexibility, and memory efficiency. It introduces a function-composition operator and placeholders for clearer higher-order-function expressions, row-based insertion quotas, new array and map functions, optional SQL-compatible integer division, and disk spilling for large IN-subquery sets. Performance improvements include faster GROUP BY operations on LowCardinality columns, Top-K dynamic filtering for grouped queries that can skip substantial data reads, an experimental decoded-columns cache for repeated scans, and string-filter evaluation during deserialization to reduce memory use. The release also adds experimental LATERAL JOIN support, arbitrary JOIN conditions such as pattern-based matches, Freeform parsing for structured text input, and SQLite import/export capabilities, while recognizing contributions from numerous new community members.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.