starrocks-ddl-table-types

What problem does it solve?

This Skill helps you choose the correct StarRocks table type and write correct CREATE TABLE DDL so your data ingest semantics (append, upsert, dedup, and CDC) match the storage and merge behavior.

Core Features & Use Cases

• Table-type decision guidance: Choose among Duplicate Key, Aggregate Key, Unique Key, and Primary Key based on whether you need append-only throughput, pre-aggregation, deduplication, or full upsert/delete.
• DDL correctness for keys and semantics: Define key columns, ensure key-column rules (prefix/sort-key constraints), and pick appropriate aggregate functions for Aggregate Key.
• CDC and real-time design support: Create Primary Key CDC target tables with proper MVCC expectations and when to enable persistent index for scale.
• Use Case: Build an ODS append-only events table with DUPLICATE KEY, then load and roll up daily metrics into an AGGREGATE KEY table using SUM/MAX/MIN/HLL_UNION/BITMAP_UNION, and maintain a CDC dimension with PRIMARY KEY that supports UPDATE and DELETE.

Quick Start

Ask the AI to generate a StarRocks CREATE TABLE DDL for your intended workload and explain which of Duplicate Key, Aggregate Key, Unique Key, or Primary Key you should use based on your need for UPDATE/DELETE, dedup rules, and any required pre-aggregation functions.