Compression

Dictionary Encoding Delta Encoding Bitmap Encoding Bit Packing / Mostly Encoding

Concurrency Control

Multi-version Concurrency Control (MVCC)

Data Model

Column Family / Wide-Column Relational

Fault Tolerance

Quorum-based Replication Read Repair Synchronous Replication Asynchronous Replication

Foreign Keys

Supported

StarRocks uses foreign keys for performance enhancements, while users can declare foreign keys, but they are not enforced.

Indexes

BitMap Inverted Index (Full Text)

StarRocks supports a wide range of secondary indexes, including prefix index, bitmap index, bloomfilter index, n-gram index, inverted index, and ANN (Approximate Nearest Neighbor) indexes.

Joins

Nested Loop Join Hash Join Broadcast Join Shuffle Join

StarRocks is MPP and is able to perform in-memory data shuffling.

Parallel Execution

Intra-Operator (Horizontal)

Query Compilation

JIT Compilation

StarRocks uses vectorization without query compilation globally. Its expression uses JIT compilation.

Query Interface

SQL

Storage Architecture

Disk-oriented Hybrid

Storage Format

Apache Iceberg Apache Hudi Custom

StarRocks has its own storage formats and can directly query data stored in Apache Hudi, Apache Iceberg, Delta and Paimon formats.

Storage Model

Decomposition Storage Model (Columnar)

System Architecture

Shared-Nothing Shared-Everything

User-Defined Functions

Python Java

Views

Virtual Views Materialized Views

StarRocks Materialized View supports multi-table queries and can perform query rewrites during query execution.