Skip to content
Problems.

Trouble with ClickHouse table

Databases4 posts from 3 people2d active+44 posts in the last 7 days, 0 the 7 days before (new)

Posts per day

Posts per day4 posts, Sep 21 to Sep 27

The posts behind it

4, newest first
PostDate
Cache dictionary table read fabricates a DEFAULT row for a deleted source key### Describe what's wrong - Reading a `cache`, `complex_key_cache` or `ssd_cache` dictionary as a table can return a row for a key that exists nowhere. - Trigger: a cached cell expires per `LIFETIME` and the key has since been deleted from the source. - Expected: the row is...ClickHouse/ClickHouseclickgapaiSep 225 days ago
Distributed-destination INSERT SELECT still forwards the plain table function### Describe what's wrong - `INSERT INTO SELECT * FROM url(...)` inserts the source data once per destination shard - Triggered with `parallel_replicas_for_cluster_engines = 1`, `enable_parallel_replicas = 1`, `cluster_for_parallel_replicas` set and...ClickHouse/ClickHouseclickgapaiSep 216 days ago
Wrong results: `variantElement` over a `Merge` table returns `NULL` unless it is in the top-level projection...`multiIf` into a subquery projection and filtering on its alias in the outer query is a workaround and produces the documented rows. Related: https://github.com/ClickHouse/ClickHouse/issues/121166ClickHouse/ClickHousealexey-milovidovSep 216 days ago
clickhouse local: table/dictionary names longer than NAME_MAX raise std::filesystem_error (code 1001) instead of UNKNOWN_TABLEIn `clickhouse local`, any query naming a table or dictionary with more than 255 bytes in its name fails with `std::filesystem_error` (`Code 1001 (STD_EXCEPTION)`) instead of a normal `UNKNOWN_TABLE` / "Dictionary not found". The default database in `clickhouse local` overlays...ClickHouse/ClickHouseqoegaSep 216 days ago

Companies and products named

Company or productPosts naming it
ClickHouse4
GitHub3
About this problem

Evidence

4 posts from 3 people in 1 place, about 4 a week over 2 days. Mostly on ClickHouse/ClickHouse. Tools named alongside: GitHub.

Frustration Frustration 0 of 3· Seen on GitHub issues

How it was grouped

Posts about ClickHouse with no known issue, sharing the word "table". First post Sep 21, 2026, latest Sep 22, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

History

  • 2026-09-27 Added: Trouble with ClickHouse table (4 posts)

Rising problems by email

Mondays: the problems in data, tech and AI that grew fastest that week.

Double opt-in. Unsubscribe any time.