ClickHouse
Alternative

Mutable data is a common byproduct of business activities. It can be caused by glitches in the underlying data pipeline or it can simply be a part of normal business logic.

ClickHouse, like most other analytical databases, doesn't have native support for UPDATE and DELETE operations. Instead, it provides a MUTATION operation to asynchronously ALTER TABLE. ClickHouse's asynchronous MUTATION operations can cause degraded and unpredictable query latency when there are frequent data ingestions. This is not suitable for real-time analytics with data mutations.

StarRocks' primary key table is designed to handle mutated data analytics natively. Using its primary key index, data changes are resolved at data ingestion, delivering uncompromising query performance to users.

ClickHouse's performance only lasts as long as you're doing aggregation queries. Once scenarios become more demanding, like complex, high-concurrency queries, performance starts to crater.

StarRocks has none of these limitations. With a blazing-fast execution engine and a suite of advanced features like its built-in cost-based optimizer, StarRocks accelerates queries by reusing cached and saved query results. This makes it great for scaling concurrency in any scenario.

StarRocks' materialized view (MV) works seamlessly with the supports of incremental updated (sync' MV only) and automatic query rewrite.

StarRocks' query cache can save intermediate computation results of executed queries. New queries that are (partially) semantically equivalent can reuse the cached results.