Apache Doris

MPP columnar analytical database with duplicate, aggregate and unique key table models.

Provider: default
Kind: Data warehouse
Category: Data
Official docs: https://doris.apache.org/docs/3.x/table-design/data-model/overview/

Properties · 4 set by this component

property	type	values	required	kind default	this component
deployment · component property	enum	storage-compute-coupled \| storage-compute-decoupled	no	storage-compute-coupled	inherited
format	enum	columnar \| row	no	columnar	▸ columnar
managed	boolean	—	no	false	▸ false
realtime	boolean	—	no	false	▸ true
tableModel · component property	enum	duplicate-key \| aggregate-key \| unique-key	no	duplicate-key	inherited
upsert	boolean	—	no	false	▸ 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: "doris", component: "doris" }

Other Data warehouse products · 39

AnalyticDBalibaba-analyticdbalibabaclouddata-warehouse ApsaraDB for ClickHousealibaba-clickhousealibabaclouddata-warehouse Hologresalibaba-hologresalibabaclouddata-warehouse MaxComputealibaba-maxcomputealibabaclouddata-warehouse ApsaraDB for SelectDBalibaba-selectdbalibabaclouddata-warehouse Amazon Athenaaws-athenaawsdata-warehouse Amazon Redshiftredshiftawsdata-warehouse Azure Analysis Servicesazure-analysis-servicesazuredata-warehouse Microsoft Fabricazure-fabricazuredata-warehouse Azure Synapse Analyticsazure-synapseazuredata-warehouse R2 SQLcloudflare-r2-sqlcloudflaredata-warehouse ClickHouseclickhousedata-warehouse Generic data warehousedata-warehousedata-warehouse Databricks SQLdatabricks-sqldata-warehouse Dremiodremiodata-warehouse Apache Drilldrilldata-warehouse Apache Druiddruiddata-warehouse DuckDBduckdbdata-warehouse Exasolexasoldata-warehouse Fireboltfireboltdata-warehouse Greenplumgreenplumdata-warehouse Apache Hivehivedata-warehouse Apache Impalaimpaladata-warehouse Apache Kylinkylindata-warehouse MonetDBmonetdbdata-warehouse MotherDuckmotherduckdata-warehouse Apache Pinotpinotdata-warehouse Prestoprestodata-warehouse Snowflakesnowflakedata-warehouse StarRocksstarrocksdata-warehouse Teradata Vantageteradatadata-warehouse Trinotrinodata-warehouse Verticaverticadata-warehouse Google BigQuerybigquerygcpdata-warehouse Db2 Warehouse as a Serviceibm-db2-warehouseibmdata-warehouse Netezza Performance Server as a Serviceibm-netezzaibmdata-warehouse IBM watsonx.dataibm-watsonx-dataibmdata-warehouse Autonomous AI Lakehouseoci-autonomous-data-warehouseocidata-warehouse MySQL HeatWave clusteroci-mysql-heatwave-clusterocidata-warehouse

Source

1# yaml-language-server: $schema=../../schema/component.schema.json
2# Apache Doris: MPP columnar analytical database. "Table type overview": Duplicate Key is the
3# default table type storing raw records, while Unique Key tables keep only the latest row per key
4# and support UPDATE, so upserts are opt-in through the table model chosen at creation.
5schemaVersion: "1"
6type: "component"
7id: "doris"
8kind: "data-warehouse"
9provider: "default"
10docs: "https://doris.apache.org/docs/3.x/table-design/data-model/overview/"
11defaults:
12  realtime: true
13  upsert: false
14  format: "columnar"
15  managed: false
16properties:
17  tableModel:
18    type: "enum"
19    values: ["duplicate-key", "aggregate-key", "unique-key"]
20    default: "duplicate-key"
21  deployment:
22    type: "enum"
23    values: ["storage-compute-coupled", "storage-compute-decoupled"]
24    default: "storage-compute-coupled"

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