Data and AI struggles

1,307 problems · 307 companies

Databases

Trouble with ClickHouse return

3 posts from 3 people3d activeSteady, +1 this week

Posts per day

Posts per day3 posts, Oct 4 to Oct 28

The posts behind it

GitHub issuesClickHouse/ClickHouse · MicroMiloOct 26

Docs: h3GetResolution incorrectly says invalid indexes return a random value

### Describe the issue The manual H3 function reference says that `h3GetResolution` returns a random value when the input is not a valid H3 index: https://github.com/ClickHouse/ClickHouse/blob/master/docs/reference/functions/regular-functions/geo/h3.mdx#L69 The current...

1 replies
GitHub issuesClickHouse/ClickHouse · clickgapaiOct 15

Five Trino aliases return non-Trino results

### Describe what's wrong - `to_base64url`, `url_encode`, `url_extract_host`, `url_extract_protocol` and `slice` diverge from Trino semantics. - Triggered by running Trino's own test vectors for these functions on ClickHouse. - Each alias silently returns a different value...

GitHub issuesClickHouse/ClickHouse · r33s3n6Oct 4

substring with a constant offset 0 throws on a non-constant string, other argument shapes return an empty string

### Describe what's wrong `substring(s, 0, len)` throws `Indices in strings are 1-based` when `s` is a column and the offset is a constant. With a constant string, or with the offset as a column, the same call returns an empty string, which is what the documentation says. -...

1 replies

Companies and products named

3 posts
3 posts
1 post
About this problem

Evidence

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

Frustration Frustration 0 of 3· Seen on GitHub issues

How it was grouped

Posts about ClickHouse with no known issue, sharing the word "return". First post Oct 4, 2026, latest Oct 26, 2026. Corroborated: 3 or more posts from 2 or more people or places. Method

Other ClickHouse problems

ClickHouse users keep filing bugs

Top post: "Tighten seccomp policy for optional kernel interfaces", one of 35 posts from 13 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 7 posts from 5 people on GitHub issues.

ClickHouse upgrades break working setups

23 posts from 14 people on GitHub issues.

ClickHouse costs outgrow the value it gives

9 posts from 3 people on GitHub issues.

Trouble with ClickHouse database

Top post: "`DROP NAMED COLLECTION` succeeds while a database uses the collection, and the server then fails to start", one of 6 posts from 2 people on GitHub issues.

Experiments on ClickHouse are hard to reproduce and track

7 posts from 1 person on GitHub issues. Unverified.

ClickHouse error messages are cryptic

5 posts from 3 people on GitHub issues.

Trouble with ClickHouse read

Top post: "ORC: a corrupt PostScript `metadata_length` makes ORC predicate pushdown read `stripe_stats` out of bounds,", one of 4 posts from 4 people on GitHub issues.

Trouble with ClickHouse join

Top post: "Explicit grace_hash now spills at max_bytes_ratio_before_external_join = 0.5 although the build side fits in", one of 4 posts from 3 people on GitHub issues.

Trouble with ClickHouse name

Top post: "SIGSEGV reading a `7z` archive entry without a name", one of 3 posts from 2 people on GitHub issues.

ClickHouse rate limits and usage caps block work

3 posts from 3 people on GitHub issues.

Trouble with ClickHouse merge

Top post: "GROUP BY over a near-unique key with ORDER BY count() DESC LIMIT n: bound group counts before counting them", one of 3 posts from 2 people on GitHub issues.

History

First seen with 3 posts; the top post now: "Docs: h3GetResolution incorrectly says invalid indexes return a random value".

Oct 28, 2026