Problemsby GlyphAll problems
51 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.
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.
PostgreSQL hits connection, locking and scaling limits
3 posts from 3 people on Reddit, GitHub issues, Stack Overflow.
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.
Trouble with PostgreSQL table
Top post: "`CREATE TABLE ... AS mysql(..., SETTINGS ...)` and `AS postgresql(..., SETTINGS ...)` do not store the", one of 3 posts from 3 people on GitHub issues, Reddit.
Trouble with Apache Iceberg delete
Top post: "Iceberg DROP PARTITION aborts or republishes parent delete counters after an overwrite snapshot", one of 3 posts from 3 people on GitHub issues.
ClickHouse rate limits and usage caps block work
3 posts from 3 people on GitHub issues.
Trouble with Polars read
Top post: "`read_database` raises `ImportError` with SQLAlchemy 2.1 when `greenlet` is not installed", one of 3 posts from 3 people on GitHub issues.
Apache Iceberg connectors and syncs are fragile
3 posts from 3 people on GitHub issues.
Trouble with ClickHouse silently
Top post: "Lightweight `UPDATE`s made on 26.8+ silently disappear after a rollback to 26.6: v2 patch parts are detached", one of 2 posts from 2 people on GitHub issues. Unverified.
ClickHouse vector search quality is hard to get right
2 posts from 2 people on GitHub issues. Unverified.
ClickHouse schema changes break downstream pipelines
2 posts from 1 person on GitHub issues. Unverified.
Trouble with ClickHouse view
Top post: "SQL Console (/ui): View Parameters flyout cannot be dismissed and overrides Row Details and Cell Inspector on", one of 2 posts from 2 people on GitHub issues. Unverified.
Trouble with ClickHouse indexes
Top post: "`NOT (coalesce(a, b) > c) OR ...` loses rows with combined skip indexes", one of 2 posts from 2 people on GitHub issues. Unverified.
dbt costs outgrow the value it gives
2 posts from 1 person on GitHub issues. Unverified.
ClickHouse streams lag, drop or reorder events
2 posts from 2 people on GitHub issues, Reddit. Unverified.
Apache Kafka lock-in makes switching costly
2 posts from 2 people on Reddit, GitHub issues. Unverified.
NVIDIA costs outgrow the value it gives
2 posts from 2 people on GitHub issues. Unverified.
Trouble with ClickHouse name
Top post: "SIGSEGV reading a `7z` archive entry without a name", one of 2 posts from 2 people on GitHub issues. Unverified.
Trouble with ClickHouse return
Top post: "substring with a constant offset 0 throws on a non-constant string, other argument shapes return an empty", one of 2 posts from 2 people on GitHub issues. Unverified.
Trouble with ClickHouse null
Top post: "ORDER BY elided after sort through negate, wrong NaN/NULL placement", one of 2 posts from 1 person on GitHub issues. Unverified.
ClickHouse permissions are confusing and error-prone
2 posts from 2 people on GitHub issues. Unverified.
ClickHouse hits connection, locking and scaling limits
2 posts from 2 people on GitHub issues. Unverified.