Data & Storage

Use cases

When analytical queries span hundreds of millions of rows and response time matters, Jiau Insight can push them down to ClickHouse and keep the interaction at sub-second speed.

Capabilities

• Supports distributed tables, materialized views and common table engines
• Predicate pushdown and pre-aggregation hints to avoid full-table scans
• Time semantics in metric definitions are mapped to partition-pruning conditions automatically
• Per-tenant resource queues and query timeouts prevent noisy-neighbour effects

Prerequisites

Use a read-only account and cap memory and execution time per query. For the first connection, run a quick assessment of data volume and partition distribution.