---
title: "ClickHouse Release 26.4"
description: "ClickHouse Release 26.4 introduces 39 new features, 45 performance optimizations, and 238 bug fixes, focusing on broader SQL compatibility and indexing improvements. The update expands standard SQL support by allowing VALUES clauses as table expressions with column aliases, PostgreSQL-style EXTRACT units, NATURAL JOIN, and SET TIME ZONE commands. For text search, LIKE and ILIKE pattern queries using splitByNonAlpha tokenizers scan inverted index dictionaries instead of executing full-table scans when the dedicated evaluation setting is active. The release also provides the JSONAllValues function to extract all leaf values from a JSON column into a string array, enabling text skip indexes that significantly reduce scanned data and improve query latency."
---

# ClickHouse Release 26.4

[Clickhouse](https://yomu.fyi/company/clickhouse) · ClickHouse · May 8, 2026

**Type:** Announcement

## Summary

ClickHouse Release 26.4 introduces 39 new features, 45 performance optimizations, and 238 bug fixes, focusing on broader SQL compatibility and indexing improvements. The update expands standard SQL support by allowing VALUES clauses as table expressions with column aliases, PostgreSQL-style EXTRACT units, NATURAL JOIN, and SET TIME ZONE commands. For text search, LIKE and ILIKE pattern queries using splitByNonAlpha tokenizers scan inverted index dictionaries instead of executing full-table scans when the dedicated evaluation setting is active. The release also provides the JSONAllValues function to extract all leaf values from a JSON column into a string array, enabling text skip indexes that significantly reduce scanned data and improve query latency.

## Context

ClickHouse required updates to expand standard SQL syntax compatibility and provide faster evaluation for text search and JSON filtering workloads.

## Approach / What changed

ClickHouse 26.4 introduces table expressions and column aliasing for VALUES, PostgreSQL-style units for EXTRACT, and SET TIME ZONE support. It enables inverted index dictionary scanning for LIKE queries using splitByNonAlpha tokenizers via use\_text\_index\_like\_evaluation\_by\_dictionary\_scan and adds the JSONAllValues function to build text skip indexes over JSON subcolumns.

## Takeaways

- ClickHouse 26.4 supports using VALUES as a table expression with aliased columns and adds PostgreSQL-style unit support to the EXTRACT operator.
- Queries using LIKE or ILIKE with splitByNonAlpha tokenizers can scan the inverted index dictionary directly to avoid full-table scans.
- The JSONAllValues function extracts all leaf values of a JSON column as Array(String), allowing n-gram text skip indexes to accelerate JSON subcolumn filtering.

**Tags:** [Open Source](https://yomu.fyi/topic/open-source), [Performance](https://yomu.fyi/topic/performance), [Search](https://yomu.fyi/topic/search)

- Source: [Clickhouse](https://clickhouse.com/blog/clickhouse-release-26-04)
- Source URL: https://clickhouse.com/blog/clickhouse-release-26-04
- Ingested by Yomu: 2026-08-28T01:25:38.152Z

[Read original post](https://clickhouse.com/blog/clickhouse-release-26-04)