ClickHouse / ClickHouse/ClickHouse

UPDATE mutation targets all the parts of the table despite specifying a partition ID on replicatedmergetree

Open
#72,899 5 comments 0 reactions 0 assignees View on GitHub
comp-mutations external performance
Dominant language
C++
Stars
49.9k
Forks
9k
Avg merge
21h 32m
Merged PRs (30d)
515

Description

(you don't have to strictly follow this form)

**Company or project name**
Mobula Labs - blockchain data infra

**Describe the situation**
The UPDATE mutation triggers a lot of different parts, while I'm specifying a partition ID.

* Which ClickHouse server version to use
* 24.9.2.42

* Queries to run that lead to slow performance
ALTER table default.evm_blocks UPDATE _row_exists = 0 IN PARTITION ID '00077af8923c3742a94752a6b0fcddbd' where number < 0

**Expected performance**
Should only target parts of my partition, instead targets all the parts of the table.``

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.