Who provides enterprise support for ClickHouse?
ClickHouse, Inc. supports its Cloud customers with published response times. For self-managed clusters on VMs or Kubernetes, independent providers like AceMQ cover operations, schema and query problems around the clock.
What does 24/7 ClickHouse support cover with AceMQ?
A senior engineer on a live call at any hour for P1s such as stopped ingest, queries failing on all shards or a full disk blocking merges, plus a written root cause for every P1 and help with tuning and upgrades.
What fixes "too many parts" in ClickHouse?
Batching at the producer, because every insert creates at least one part per partition and merges cannot keep up with thousands of tiny inserts a second. Tens of thousands of rows per insert is normal, or async_insert lets the server buffer. Correct a high-cardinality partition key too. Raising the limit trades an error today for a slower cluster tomorrow.
Why does my filtered query still scan the whole table?
ClickHouse has no per-column indexes like a row store. The primary index is sparse over the ORDER BY key and skips granules only when the filter matches a key prefix. Filtering on the second key column alone prunes nothing. Options are a skipping index, a projection with a different order, or a rebuilt table; we measure which wins on your data.
An ALTER TABLE UPDATE has run for days. Can it be stopped?
Yes, with KILL MUTATION; already rewritten parts stay valid. The better question is why it was needed. Mutations rewrite every affected part. Lightweight deletes, ReplacingMergeTree with FINAL at query time or a partition-scoped rewrite avoid whole-table rewrites.
What causes ClickHouse replication lag and how is it fixed?
Slow or overloaded Keeper, a replica unable to fetch a part from a busy source, or a mutation stuck at the head of the queue. We relieve the coordination service, clear the blocking entry on purpose and size merge pools and storage for the ingest rate. The system tables show it quickly on the first call.
Do you support ClickHouse Cloud as well as self-managed clusters?
Yes, with the same engineers. Cloud removes Keeper and storage provisioning, but schema design, sorting keys, join memory, mutation cost and insert batching still decide most tickets. ClickHouse's own support covers the Cloud product.
Which ClickHouse versions do you support?
The release you run. SECURITY.md currently lists 26.10, 26.9, 26.8 and 26.3 for security fixes (read 17 Nov 2026); we support others and plan the move to a listed release.
Can you upgrade our ClickHouse cluster?
Yes: version and client inventory, a staging rehearsal against your real query mix, replicas first, then a controlled order and a written rollback. We also check materialized views and TTL behaviour on the new version.
What does a ClickHouse health check include?
Part counts and merge lag per table, sorting and partition key review against the query log, memory limit behaviour, replication queue and Keeper latency, mutation backlog, disk and TTL status, and a ranked plan. Quotes are answered within 1 hour.
Who offers ClickHouse consulting and professional services?
ClickHouse, Inc. offers professional services with its Cloud plans, per its support page, and independent firms such as AceMQ consult on self-managed and Cloud ClickHouse alike. Our consultants staff the 24/7 rota, so recommendations come with the knowledge of how a design fails. See ClickHouse consulting.
Can we buy a ClickHouse health check first and decide on support later?
Yes. A health check covers part counts, merge lag, sorting keys, memory limits, the replication queue and mutation backlog, and ends with a ranked plan. Many teams then add annual 24/7 support, often with the same engineer who did the review.
How do you price ClickHouse support?
Annual contracts run $24,000 to $72,000 (USD). The inputs are shard and replica count, data volume and daily ingest, Keeper layout, self-managed or Cloud, and the response plan. Send us those figures and the quote comes back within 1 hour.