ClickHouse Release 26.7

ClickHouse 26.7 introduces 61 features, 112 performance optimizations, and 329 bug fixes, with major work focused on query execution, joins, vector search, observability, federation, and usability. New ordered aggregation optimizations can stream and stop early for suitable GROUP BY, ORDER BY, and LIMIT queries, producing benchmarked reductions of up to 313× in runtime and 592× in peak memory, while join enhancements allow build-side keys to prune unread probe-side granules, compact hash-table row references, and add the DPsub join-ordering algorithm. Vector-search updates expand QBit with Int8 quantization, configurable dimension strides, randomized Hadamard transforms, and quantization codecs for approximate candidate selection followed by exact rescoring. Experimental position-aware text indexes accelerate phrase matching, and EXPLAIN ANALYZE now executes queries while reporting planning and execution times, data flow, memory use, and observed parallelism. Other additions include persistent Remote and RemoteSecure engines, unified URL access across storage backends, DateTime64 support from years 0000 through 9999, the groupFormat aggregate function, experimental SQL-defined executable UDF drivers, an expanded embedded SQL web workspace with version-matched local documentation, JIT-compiled regular expressions, and improved macOS performance and functionality.

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.