ClickHouse version 25.12 contains 26 new features 🎄 31 performance optimizations `⛸` 129 bug fixes ☃
This release we have faster top-n queries with data skipping indexes, faster lazy reading with join-style execution model, and more! ## New contributors A special welcome to all the new contributors in 25.12! The growth of ClickHouse's community is humbling, and we are always grateful for the contributions that have made ClickHouse so popular. Below are the names of the new contributors: *Alex Soffronow Pagonidis, Alexey Bakharew, Govind R Nair, Jeremy Aguilon, Kirill Kopnev, LeeChaeRok, MakarDev, Paresh Joshi, Revertionist, Sam Kaessner, Seva Potapov, Shaurya Mohan, Sümer Cip, Yonatan-Dolan, alsugiliazova, htuall, ita004, jetsetbrand, mostafa, punithns97, rainac1* Hint: if you’re curious how we generate this list… [here](https://gist.github.com/gingerwizard/5a9a87a39ba93b422d8640d811e269e9). You can also [view the slides from the presentation](https://presentations.clickhouse.com/2025-release-25.12/). ## Faster Top-N queries with data skipping indexes ### Contributed by Shankar Iyer > **Why this matters** ClickHouse is the fastest production-grade analytical DBMS on [ClickBench](https://benchmark.clickhouse.com/), a benchmark based on [real-world web analytics traffic](https://github.com/ClickHouse/ClickBench/?tab=readme-ov-file#overview) with results published for more than 70 database systems. It is also the fastest production-grade analytical system on [JSONBench](https://jsonbench.com/) among all major engines with first-class JSON support.
SELECT *
FROM hits
ORDER BY EventTime
LIMIT 100000
FORMAT Hash
SETTINGS query_plan_max_limit_for_lazy_materialization = 0;
EXPLAIN PLAN
SELECT *
FROM hits
ORDER BY EventTime
Limit 100000
SETTINGS query_plan_max_limit_for_lazy_materialization = 0;
SET allow_experimental_analyzer = 1;
SET query_plan_optimize_join_order_limit = 10;
SET allow_statistic_optimize = 1;
SET query_plan_join_swap_table='auto';
SET enable_parallel_replicas = 0;
SELECT
n_name,
sum(l_extendedprice * (1 - l_discount)) AS revenue
FROM
customer,
orders,
lineitem,
supplier,
nation,
region
WHERE
c_custkey = o_custkey
AND l_orderkey = o_orderkey
AND l_suppkey = s_suppkey
AND c_nationkey = s_nationkey
AND s_nationkey = n_nationkey
AND n_regionkey = r_regionkey
AND r_name = 'ASIA'
AND o_orderdate >= DATE '1994-01-01'
AND o_orderdate < DATE '1994-01-01' + INTERVAL '1' year
GROUP BY
n_name
ORDER BY
revenue DESC
SETTINGS
query_plan_optimize_join_order_algorithm = 'greedy';
-- query_plan_optimize_join_order_algorithm = 'dpsize';
SET enable_full_text_index=1;
CREATE TABLE hackernews
(
`id` Int64,
`deleted` Int64,
`type` String,
`by` String,
`time` DateTime64(9),
`text` String,
`dead` Int64,
`parent` Int64,
`poll` Int64,
`kids` Array(Int64),
`url` String,
`score` Int64,
`title` String,
`parts` Array(Int64),
`descendants` Int64,
INDEX inv_idx(text)
TYPE text(tokenizer = 'splitByNonAlpha')
GRANULARITY 128
)
ORDER BY time;
SELECT by, count()
FROM hackernews
WHERE hasToken(text, 'OpenAI')
GROUP BY ALL
ORDER BY count() DESC
LIMIT 10;
SELECT by, count()
FROM hackernews
WHERE hasAllTokens(text, ['OpenAI', 'Google'])
GROUP BY ALL
ORDER BY count() DESC
LIMIT 10;
SELECT by, count()
FROM hackernews
WHERE hasAnyTokens(text, ['OpenAI', 'Google'])
GROUP BY ALL
ORDER BY count() DESC
LIMIT 10;
SELECT by, count()
FROM hackernews
WHERE text LIKE '%OpenAI%'
GROUP BY ALL
ORDER BY count() DESC
LIMIT 10;
SELECT by, count()
FROM hackernews
WHERE text LIKE '% OpenAI %'
GROUP BY ALL
ORDER BY count() DESC
LIMIT 10;
CREATE DICTIONARY taxi_zone_dictionary
(
LocationID UInt16 DEFAULT 0, -- key
Borough String, -- attributes
Zone String,
service_zone String
)
PRIMARY KEY LocationID
SOURCE(HTTP(URL 'https://datasets-documentation.s3.eu-west-3.amazonaws.com/nyc-taxi/taxi_zone_lookup.csv' FORMAT 'CSVWithNames'))
LIFETIME(MIN 0 MAX 0)
LAYOUT(HASHED_ARRAY());
SELECT dictGet('taxi_zone_dictionary', ('Borough', 'Zone'), 240);
SELECT dictGetKeys('taxi_zone_dictionary', 'Borough', 'Bronx')
SELECT dropoff_nyct2010_gid, payment_type, count()
FROM trips
WHERE dropoff_nyct2010_gid IN (payment_type = 'CSH' ? [138] : [132])
GROUP BY ALL;
profiles:
default:
allow_get_client_http_header: 1
CREATE TABLE webhook_staging (
received_at DateTime DEFAULT now(),
raw_payload String,
signature String DEFAULT getClientHTTPHeader('X-Hub-Signature-256')
) ENGINE = MergeTree()
ORDER BY received_at;
CREATE TABLE webhook_prod (
received_at DateTime,
event_type String,
payload String
) ENGINE = MergeTree()
ORDER BY received_at;
CREATE MATERIALIZED VIEW webhook_validator TO webhook_prod AS
SELECT
received_at,
raw_payload::JSON.event as event_type,
raw_payload as payload
FROM webhook_staging
WHERE signature = 'sha256=' || lower(hex(HMAC('SHA256', raw_payload, 'my_secret_key')));
PAYLOAD='{"event":"user_signup","user_id":789}'
SIGNATURE=$(echo -n "$PAYLOAD" | openssl dgst -sha256 -hmac "my_secret_key2" | cut -d' ' -f2)
curl -X POST "http://localhost:8123/?query=INSERT%20INTO%20webhook_staging%20(raw_payload)%20FORMAT%20RawBLOB"
-H "X-Hub-Signature-256: sha256=$SIGNATURE"
-d "$PAYLOAD"
SELECT
received_at,
raw_payload::JSON.event as event_type,
raw_payload as payload,
signature,
'sha256=' || lower(hex(HMAC('SHA256', raw_payload, 'my_secret_key')))
FROM webhook_staging