starrocks
The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRock
What is starrocks?
The world's fastest open query engine for sub-second analytics both on and off the data lakehouse. With the flexibility to support nearly any scenario, StarRocks provides best-in-class performance for multi-dimensional analytics, real-time analytics, and ad-hoc queries. A Linux Foundation project.
Overview of starrocks
What it is
StarRocks is an open-source, high-performance analytical database designed for sub-second query response times in a variety of analytics workloads. It is a Linux Foundation project licensed under Apache 2.0. The project describes itself as the world's fastest open query engine for sub-second, ad-hoc analytics both on and off the data lakehouse. It supports both shared-nothing and shared-data architectures.
Key features
- Native vectorized SQL engine that uses vectorization technology to leverage CPU parallel computing, claiming 5 to 10 times faster performance than previous systems.
- Standard ANSI SQL support with full TPC-H and TPC-DS compatibility, plus MySQL protocol compatibility.
- Smart query optimization via a Cost Based Optimizer (CBO) for improved execution plans.
- Real-time update model allowing upsert/delete operations by primary key without sacrificing query efficiency.
- Intelligent materialized views that auto-update during data import and auto-select during queries.
- Direct querying of data in data lakes (Apache Hive, Apache Iceberg, Delta Lake, Apache Hudi) without importing.
- Resource management for limiting resource consumption and enabling multi-tenant isolation.
- Simple architecture for easy deployment, maintenance, and scaling; automatic query tuning, resource balancing during scaling, and automatic replica recovery on node failure.
Use cases
The project mentions multi-dimensional analytics, real-time analytics, and ad-hoc queries as use cases. It is used by companies including Airbnb, Alibaba, Amazon, Cisco, Coinbase, Didi, Grab, Intuit, Pinterest, Roblox, Shopee, Tencent, and Trip.com, among others listed in the README.
Getting started
To get started, refer to the repository's Quick Starts documentation. Example commands are not provided in the README. See the repository README for details.
License and pricing
StarRocks is licensed under Apache License 2.0. It is an open-source project with no stated pricing.
Based on the project's public README and repository metadata.