Specialized open-source real-time OLAP databases provide sub-second analytics performance. Key tools include ClickHouse, Apache Druid, Apache Kylin, Apache Pinot, Apache Doris, and StarRocks, each offering unique features and strengths. Vendor solutions like Rockset, DuckDB, Firebolt, and Kinetica are also highlighted. The post discusses strengths such as multidimensional analysis, SQL compatibility, resilience, and scalability, with examples of leading companies using these systems in production.
Table of contents
Real-time OLAP systems (Open source)ClickHouseApache DruidApache PinotApache DorisStarRocksApache Kylin60 Impressions