ClickHouse Release 26.7 | ClickHouse
clickhouse.com
This release brings speedups for GROUP BY ... ORDER BY ... LIMIT, three JOIN improvements, four vector search improvements, position-aware phrase search, EXPLAIN ANALYZE, unified URL access, and more!
  • New contributors
  • Faster GROUP BY … ORDER BY … LIMIT
  • The right side of a JOIN can now prune the left
  • Smaller JOIN hash tables with packed row references
  • DPsub: a third JOIN-ordering algorithm
  • Faster vector search with QBit
  • QBit: flexible Int8 quantization
  • QBit: read fewer dimensions with strided storage
  • Better quantization with randomized Hadamard rotations
  • Quantization codecs: fast two-stage vector search
  • Position for phrase matching
  • EXPLAIN ANALYZE
  • Remote and RemoteSecure engines
  • Unification of URL
  • DateTime64: Years 0 to 9999
  • groupFormat
  • Drivers for executable UDFs
  • The built-in Web UI grows into a real SQL workspace
  • Instant, version-matched reference docs
  • Regular expressions, compiled to native code
  • ClickHouse gets faster on macOS