u/MortarGoBoomBoom

We are evaluating OLAP databases for a new real-time analytics feature in our app. ClickHouse keeps coming up, but every review I read mentions a brutal learning curve and significant operational complexity if you want to run it in production.

I am worried that we will spend months just learning how to properly configure sort keys, materialized views, and cluster topologies before we even ship a single API endpoint to our frontend. For those running it in production: is the raw performance actually worth the engineering overhead, or are there better tools for building user-facing analytics quickly?

We have been using Aiven for our managed Kafka and ClickHouse pipelines, and while the initial setup was easy, the cost at scale is absolutely bleeding our budget. Sustained high ingest and hourly ETLs are racking up a massive 'convenience tax'.

On top of the pricing, when our real-time pipeline inevitably hits a snag or lag spikes, debugging within their managed environment feels like a black box. We are at the mercy of their support tooling. Are there alternatives that offer a better developer experience for real-time analytics without the exorbitant pricing model as you scale to terabytes?