Problemsby GlyphClickHouse
65 problems218 posts+16 this week
Problem posts per week
ClickHouse problems
ClickHouse upgrades break working setups
31 posts from 20 people on GitHub issues.
Data pipelines fail silently or break often
19 posts from 19 people on GitHub issues, Reddit, Stack Overflow.
Login, SSO and OAuth flows break
24 posts from 24 people on GitHub issues, Reddit, App Store reviews.
Trouble with ClickHouse column
Top post: "MaterializedPostgreSQL: reading a Nullable column's .null subcolumn (x IS NULL, count(x)) fails with", one of 15 posts from 9 people on GitHub issues.
Apache Iceberg users keep filing bugs
Top post: "ORC: Writer accepts an empty struct that reader cannot bind", one of 11 posts from 10 people on GitHub issues, Reddit.
ClickHouse costs outgrow the value it gives
11 posts from 3 people on GitHub issues.
Observability and logging costs outgrow the value
8 posts from 8 people on GitHub issues, Reddit.
Trouble with ClickHouse tables
Top post: "Paimon: resolve columns by field id, so tables with renamed or re-added columns are readable", one of 7 posts from 6 people on GitHub issues.
Queries run too slowly and are hard to tune
5 posts from 5 people on GitHub issues, Stack Overflow.
ClickHouse queries run too slowly and are hard to tune
3 posts from 2 people on GitHub issues.
Delta Lake upgrades break working setups
2 posts from 2 people on GitHub issues. Unverified.
Trouble with ClickHouse merges
Top post: "OPTIMIZE FINAL writes the merged part with stale metadata after waiting for running merges", one of 2 posts from 2 people on GitHub issues. Unverified.
Trouble with ClickHouse path
One post on GitHub issues: "hasAllTokens is up to 3x slower than the equivalent hasToken chain on the row-scan path; searching each". Unverified.
ClickHouse users keep filing bugs
Top post: "Tighten seccomp policy for optional kernel interfaces", one of 19 posts from 8 people on GitHub issues.
Trouble with Apache Iceberg table
Top post: "Parquet files written with the default CRS are not compatible with Iceberg Java EPSG:4326 table", one of 12 posts from 8 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 8 posts from 5 people on GitHub issues.
Experiments on ClickHouse are hard to reproduce and track
8 posts from 1 person on GitHub issues. Unverified.
Trouble with Apache Iceberg spark
Top post: "Spark: WAP snapshot isolation broken for format-version 3 tables when deletion vectors are used (spark.wap.id)", one of 7 posts from 7 people on GitHub issues.
Delta Lake users keep filing bugs
Top post: "version.sbt should be updated since 4.4.0 is out", one of 6 posts from 6 people on GitHub issues.
Apache Iceberg upgrades break working setups
6 posts from 5 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 5 posts from 4 people on GitHub issues.
Trouble with ClickHouse query
Top post: "Memory tracker counts jemalloc's freed pages as used, so a heavy query started right after another spills to", one of 4 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 4 posts from 2 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.
Apache Iceberg schema changes break downstream pipelines
3 posts from 3 people on GitHub issues.
Trouble with ClickHouse columns
Top post: "INSERT SELECT from fileCluster/urlCluster fails to fill DEFAULT columns", one of 3 posts from 2 people on GitHub issues.
Trouble with ClickHouse server
Top post: "Server crash building projection with `WHERE` on `Tuple` equality", one of 3 posts from 2 people on GitHub issues.
Trouble with Apache Iceberg tables
Top post: "Iceberg tables are much slower than MergeTree in the performance tests: subcolumns, sort order, join", one of 3 posts from 3 people on GitHub issues.
About
Problems here are about ClickHouse or name it. It is in the companies.fru.dev registry. Website: clickhouse.com.