Data and AI struggles

2,114 problems · 377 companies

Databases

Trouble with ClickHouse function

2 posts from 2 people2d activeFading, +0 this weekunverified

Posts per day

Posts per day2 posts, Oct 27 to Nov 21

The posts behind it

GitHub issuesClickHouse/ClickHouse · devcrafterNov 11

Plan-based parallel replicas: a replica throws `UNKNOWN_FUNCTION` for a WASM UDF in the plan fragment

Query-based parallel replicas (`parallel_replicas_plan_based = 0`) returns `100000`: the replica analyzes the query text and finds the function. With plan-based, the replica gets the plan fragment, and `ActionsDAG::deserialize` looks up functions only in `FunctionFactory`. WASM...

1 replies
GitHub issuesClickHouse/ClickHouse · KochetovNicolaiOct 27

Add `arrayTreePreorder` function: DFS preorder layout of a tree stored as (id, parent_id) arrays

**Use case** Tables often store trees as `(id, parent_id)` rows: spans of a trace (OpenTelemetry, LLM agent observability: `AGENT` / `GENERATION` / `TOOL` spans), comment threads, org charts, category trees. A typical question is "for every node, aggregate over its subtree",...

Companies and products named

2 posts
1 post
About this problem

Evidence

2 posts from 2 people in 1 place, about 1 a week over 16 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 "function". First post Oct 27, 2026, latest Nov 11, 2026. Unverified: fewer than 3 posts, or one person or place only. Method

Other ClickHouse problems

ClickHouse upgrades break working setups

37 posts from 21 people on GitHub issues.

ClickHouse users keep filing bugs

Top post: "Tighten seccomp policy for optional kernel interfaces", one of 22 posts from 10 people on GitHub issues.

Trouble with ClickHouse column

Top post: "Top-K reads with a `minmax` index on the sort column: read the granules with the best bounds first", one of 17 posts from 10 people on GitHub issues.

ClickHouse costs outgrow the value it gives

11 posts from 3 people on GitHub issues.

Experiments on ClickHouse are hard to reproduce and track

11 posts from 2 people on GitHub issues.

Trouble with ClickHouse table

Top post: "`SYSTEM RESTORE REPLICA` on a second replica over-bumps the table `metadata` znode version; every later", one of 9 posts from 5 people on GitHub issues.

Trouble with ClickHouse join

Top post: "JOIN runtime filter pruning drops rows for CAST(UInt8 AS Bool) probe key", one of 7 posts from 5 people on GitHub issues.

Trouble with ClickHouse read

Top post: "Bucketed `Map` serialization loses the key order in Compact parts written with", one of 6 posts from 6 people on GitHub issues.

ClickHouse error messages are cryptic

6 posts from 3 people on GitHub issues.

Trouble with ClickHouse tables

Top post: "Paimon: resolve columns by field id, so tables with renamed or re-added columns are readable", one of 5 posts from 4 people on GitHub issues.

Trouble with ClickHouse default

Top post: "`merge('', regexp)` still resolves against the shard's default database", one of 5 posts from 4 people on GitHub issues.

Trouble with ClickHouse index

Top post: "Text index: exact hasPhrase on Array columns with a position increment gap", one of 4 posts from 2 people on GitHub issues.

History

Momentum went from steady to fading.

Nov 18, 2026

Momentum went from fading to steady.

Nov 16, 2026

Momentum went from new to fading.

Nov 3, 2026

First seen with 1 post; the top post now: "Plan-based parallel replicas: a replica throws `UNKNOWN_FUNCTION` for a WASM UDF in the plan fragment".

Oct 28, 2026