doris 2.1 -Updating Data 学习笔记

1 Updating Overview

1.1 different data models:
1.1.1 Primary Key (Unique) Model:
Doris supports two storage implementations: Merge-on-Read (MoR) and Merge-on-Write (MoW)
From Doris version 2.1, the default storage method is MoW.
he primary key model supports using the UPDATE statement for small data updates and also supports batch updates through data loading.
1.1.2 Aggregate Model:
When the aggregate function is set to REPLACE or REPLACE_IF_NOT_NULL, data updates can be achieved.
1.2 Comparison of Update Capabilities for Different Models/Implementations
1.2.1 Performance C