Zeema
New design
Catalogue / data-warehouse

StarRocks

Data warehousestarrocks

Columnar analytical warehouse with real-time updates through Primary Key tables.

Provider
default
Kind
Data warehouse
Category
Data
Official docs
https://docs.starrocks.io/docs/sql-reference/sql-statements/table_bucket_part_index/CREATE_TABLE/
Properties · 4 set by this component
propertytypevaluesrequiredkind defaultthis component
deployment · component propertyenumshared-nothing | shared-datanoshared-nothinginherited
formatenumcolumnar | rownocolumnar▸ columnar
managedboolean—nofalse▸ false
realtimeboolean—nofalse▸ true
replicationNum · component propertyinteger—no3inherited
tableType · component propertyenumduplicate-key | aggregate | unique-key | primary-keynoduplicate-keyinherited
upsertboolean—nofalse▸ false
Rules that apply · 0

Every rule whose selector covers this component's kind or its category. Whether a rule fires depends on the design: its properties, its edges and its groups.

No rule reads this kind yet. That is a gap, not a guarantee.
Use it in a design
nodes:
  - { id: "starrocks", component: "starrocks" }
Other Data warehouse products · 39
AnalyticDBalibaba-analyticdbalibabaclouddata-warehouseApsaraDB for ClickHousealibaba-clickhousealibabaclouddata-warehouseHologresalibaba-hologresalibabaclouddata-warehouseMaxComputealibaba-maxcomputealibabaclouddata-warehouseApsaraDB for SelectDBalibaba-selectdbalibabaclouddata-warehouseAmazon Athenaaws-athenaawsdata-warehouseAmazon Redshiftredshiftawsdata-warehouseAzure Analysis Servicesazure-analysis-servicesazuredata-warehouseMicrosoft Fabricazure-fabricazuredata-warehouseAzure Synapse Analyticsazure-synapseazuredata-warehouseR2 SQLcloudflare-r2-sqlcloudflaredata-warehouseClickHouseclickhousedata-warehouseGeneric data warehousedata-warehousedata-warehouseDatabricks SQLdatabricks-sqldata-warehouseApache Dorisdorisdata-warehouseDremiodremiodata-warehouseApache Drilldrilldata-warehouseApache Druiddruiddata-warehouseDuckDBduckdbdata-warehouseExasolexasoldata-warehouseFireboltfireboltdata-warehouseGreenplumgreenplumdata-warehouseApache Hivehivedata-warehouseApache Impalaimpaladata-warehouseApache Kylinkylindata-warehouseMonetDBmonetdbdata-warehouseMotherDuckmotherduckdata-warehouseApache Pinotpinotdata-warehousePrestoprestodata-warehouseSnowflakesnowflakedata-warehouseTeradata Vantageteradatadata-warehouseTrinotrinodata-warehouseVerticaverticadata-warehouseGoogle BigQuerybigquerygcpdata-warehouseDb2 Warehouse as a Serviceibm-db2-warehouseibmdata-warehouseNetezza Performance Server as a Serviceibm-netezzaibmdata-warehouseIBM watsonx.dataibm-watsonx-dataibmdata-warehouseAutonomous AI Lakehouseoci-autonomous-data-warehouseocidata-warehouseMySQL HeatWave clusteroci-mysql-heatwave-clusterocidata-warehouse
Source
# yaml-language-server: $schema=../../schema/component.schema.json
# StarRocks: Apache-2.0 columnar analytical warehouse supporting real-time updates. "CREATE TABLE":
# DUPLICATE KEY is the default table type and replication_num defaults to 3. "Table types": Primary
# Key tables replace a previously loaded record with the newly loaded one, which is a real upsert.
schemaVersion: "1"
type: "component"
id: "starrocks"
kind: "data-warehouse"
provider: "default"
docs: "https://docs.starrocks.io/docs/sql-reference/sql-statements/table_bucket_part_index/CREATE_TABLE/"
defaults:
  realtime: true
  upsert: false
  format: "columnar"
  managed: false
properties:
  tableType:
    type: "enum"
    values: ["duplicate-key", "aggregate", "unique-key", "primary-key"]
    default: "duplicate-key"
  replicationNum:
    type: "integer"
    default: 3
  deployment:
    type: "enum"
    values: ["shared-nothing", "shared-data"]
    default: "shared-nothing"

The same page as markdown, for an agent: /catalogue/components/starrocks.md