StarRocks

StarRocks

StarRocks is a next-gen, high-performance analytical data warehouse that enables real-time, multi-dimensional, and highly concurrent data analysis. StarRocks has an MPP architecture and is equipped with a fully vectorized execution engine, a columnar storage engine that supports real-time updates, and is powered by a rich set of features including a fully-customized cost-based optimizer (CBO), intelligent materialized view and more. StarRocks supports real-time and batch data ingestion from a variety of data sources. It also allows you to directly analyze data stored in data lakes with zero data migration.

StarRocks is also compatible with MySQL protocols and can be easily connected using MySQL clients and popular BI tools. StarRocks is highly scalable, available, and easy to maintain. It is widely adopted in the industry, powering a variety of OLAP scenarios, such as real-time analytics, ad-hoc queries, data lake analytics and more.

Join our Slack channel for live support, discussion, or latest community news. You can also follow us on LinkedIn to get first-hand updates on new features, events, and sharing.

• Introduction
• Architecture
• Shared-data cluster
• Features

• Deploy with Docker
• Create a table
• Ingest and query data

• Understand table design
• Table types
• Data distribution
• Sort keys and prefix indexes

• Overview of data loading
• Load data from a local file system or a streaming data source using HTTP PUT
• Load data from HDFS
• Load data from cloud storage
• Continuously load data from Apache Kafka®
• Continuously load data from Apache Flink®
• Load data using Apache Spark™
• Load data using INSERT
• Realtime synchronization from MySQL

• Cost-based optimizer
• Synchronous materialized view
• Asynchronous materialized view
• Colocate Join
• Query cache

• JSON
• ARRAY
• MAP
• STRUCT

• Apache Hive™
• Apache Hudi
• Apache Iceberg
• Delta Lake
• MySQL and PostgreSQL
• Elasticsearch

• AWS
• Microsoft Azure Storage
• Google Cloud Storage
• BI tools
• IDE tools

• Manage a cluster
• Scale in and out a cluster
• Resource group
• Privileges
• Data recovery
• Tune query performance

• SQL reference
• Function reference
• Data type

• Ingestion and export
• Deployment
• SQL

• SSB benchmark
• TPC-H benchmark