This is an automated email from the ASF dual-hosted git repository.
zhangchen pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 906c5b489d3 [doc](partial update) update docs of partial update (#1103)
906c5b489d3 is described below
commit 906c5b489d30eb24ab79d6accb9fbe9c9e1acaf1
Author: bobhan1 <bh2444151...@outlook.com>
AuthorDate: Thu Sep 12 15:21:48 2024 +0800
[doc](partial update) update docs of partial update (#1103)
# Versions
- [x] dev
- [x] 3.0
- [x] 2.1
- [x] 2.0
# Languages
- [x] Chinese
- [x] English
---
docs/data-operate/update/update-of-unique-model.md | 3 +--
.../current/data-operate/update/update-of-unique-model.md | 3 +--
.../version-2.0/data-operate/update/update-of-unique-model.md | 6 +-----
.../version-2.1/data-operate/update/update-of-unique-model.md | 3 +--
.../version-3.0/data-operate/update/update-of-unique-model.md | 3 +--
.../version-2.0/data-operate/update/update-of-unique-model.md | 6 +-----
.../version-2.1/data-operate/update/update-of-unique-model.md | 3 +--
.../version-3.0/data-operate/update/update-of-unique-model.md | 3 +--
8 files changed, 8 insertions(+), 22 deletions(-)
diff --git a/docs/data-operate/update/update-of-unique-model.md
b/docs/data-operate/update/update-of-unique-model.md
index fd4d787d21c..d5090219e20 100644
--- a/docs/data-operate/update/update-of-unique-model.md
+++ b/docs/data-operate/update/update-of-unique-model.md
@@ -39,6 +39,7 @@ Note:
1. Partial updates are only supported in the Merge-on-Write implementation of
the Unique Key starting from version 2.0.
2. Starting from version 2.0.2, partial updates are supported using INSERT
INTO.
+3. Partial updates are not supported on tables with materialized views.
:::
### Use Cases
@@ -138,8 +139,6 @@ After the update, the result is as follows:
1 row in set (0.01 sec)
```
-Partial Column Updates in the Primary Key Model
-
### Notes
Due to the Merge-on-Write implementation requiring data completion during data
writing to ensure optimal query performance, performing partial column updates
using the Merge-on-Write implementation may result in a decrease in load
performance.
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/update/update-of-unique-model.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/update/update-of-unique-model.md
index c0176c3df9e..19f1725a7c1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/update/update-of-unique-model.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/data-operate/update/update-of-unique-model.md
@@ -39,6 +39,7 @@ under the License.
1. 2.0 版本仅在 Unique Key 的 Merge-on-Write 实现中支持了部分列更新能力
2. 从 2.0.2 版本开始，支持使用 INSERT INTO 进行部分列更新
+3. 不支持在有同步物化视图的表上进行部分列更新
:::
### 适用场景
@@ -136,8 +137,6 @@ INSERT INTO order_tbl (order_id, order_status) values
(1,'待发货');
1 row in set (0.01 sec)
```
-主键模型的部分列更新
-
### 使用注意
由于 Merge-on-Write 实现需要在数据写入的时候，进行整行数据的补齐，以保证最优的查询性能，因此使用 Merge-on-Write
实现进行部分列更新会有部分导入性能下降。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/data-operate/update/update-of-unique-model.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/data-operate/update/update-of-unique-model.md
index 8d49c00e5db..19f1725a7c1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/data-operate/update/update-of-unique-model.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.0/data-operate/update/update-of-unique-model.md
@@ -38,10 +38,8 @@ under the License.
注意
1. 2.0 版本仅在 Unique Key 的 Merge-on-Write 实现中支持了部分列更新能力
-
2. 从 2.0.2 版本开始，支持使用 INSERT INTO 进行部分列更新
-
-3. 2.1.0 版本将支持更为灵活的列更新
+3. 不支持在有同步物化视图的表上进行部分列更新
:::
### 适用场景
@@ -139,8 +137,6 @@ INSERT INTO order_tbl (order_id, order_status) values
(1,'待发货');
1 row in set (0.01 sec)
```
-主键模型的部分列更新
-
### 使用注意
由于 Merge-on-Write 实现需要在数据写入的时候，进行整行数据的补齐，以保证最优的查询性能，因此使用 Merge-on-Write
实现进行部分列更新会有部分导入性能下降。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/update/update-of-unique-model.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/update/update-of-unique-model.md
index c0176c3df9e..19f1725a7c1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/update/update-of-unique-model.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/data-operate/update/update-of-unique-model.md
@@ -39,6 +39,7 @@ under the License.
1. 2.0 版本仅在 Unique Key 的 Merge-on-Write 实现中支持了部分列更新能力
2. 从 2.0.2 版本开始，支持使用 INSERT INTO 进行部分列更新
+3. 不支持在有同步物化视图的表上进行部分列更新
:::
### 适用场景
@@ -136,8 +137,6 @@ INSERT INTO order_tbl (order_id, order_status) values
(1,'待发货');
1 row in set (0.01 sec)
```
-主键模型的部分列更新
-
### 使用注意
由于 Merge-on-Write 实现需要在数据写入的时候，进行整行数据的补齐，以保证最优的查询性能，因此使用 Merge-on-Write
实现进行部分列更新会有部分导入性能下降。
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/update/update-of-unique-model.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/update/update-of-unique-model.md
index c0176c3df9e..19f1725a7c1 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/update/update-of-unique-model.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-3.0/data-operate/update/update-of-unique-model.md
@@ -39,6 +39,7 @@ under the License.
1. 2.0 版本仅在 Unique Key 的 Merge-on-Write 实现中支持了部分列更新能力
2. 从 2.0.2 版本开始，支持使用 INSERT INTO 进行部分列更新
+3. 不支持在有同步物化视图的表上进行部分列更新
:::
### 适用场景
@@ -136,8 +137,6 @@ INSERT INTO order_tbl (order_id, order_status) values
(1,'待发货');
1 row in set (0.01 sec)
```
-主键模型的部分列更新
-
### 使用注意
由于 Merge-on-Write 实现需要在数据写入的时候，进行整行数据的补齐，以保证最优的查询性能，因此使用 Merge-on-Write
实现进行部分列更新会有部分导入性能下降。
diff --git
a/versioned_docs/version-2.0/data-operate/update/update-of-unique-model.md
b/versioned_docs/version-2.0/data-operate/update/update-of-unique-model.md
index 52d21f59c90..d5090219e20 100644
--- a/versioned_docs/version-2.0/data-operate/update/update-of-unique-model.md
+++ b/versioned_docs/version-2.0/data-operate/update/update-of-unique-model.md
@@ -38,10 +38,8 @@ Updating partial columns mainly refers to directly updating
certain field values
Note:
1. Partial updates are only supported in the Merge-on-Write implementation of
the Unique Key starting from version 2.0.
-
2. Starting from version 2.0.2, partial updates are supported using INSERT
INTO.
-
-3. Version 2.1.0 will support more flexible column updates.
+3. Partial updates are not supported on tables with materialized views.
:::
### Use Cases
@@ -141,8 +139,6 @@ After the update, the result is as follows:
1 row in set (0.01 sec)
```
-Partial Column Updates in the Primary Key Model
-
### Notes
Due to the Merge-on-Write implementation requiring data completion during data
writing to ensure optimal query performance, performing partial column updates
using the Merge-on-Write implementation may result in a decrease in load
performance.
diff --git
a/versioned_docs/version-2.1/data-operate/update/update-of-unique-model.md
b/versioned_docs/version-2.1/data-operate/update/update-of-unique-model.md
index fd4d787d21c..d5090219e20 100644
--- a/versioned_docs/version-2.1/data-operate/update/update-of-unique-model.md
+++ b/versioned_docs/version-2.1/data-operate/update/update-of-unique-model.md
@@ -39,6 +39,7 @@ Note:
1. Partial updates are only supported in the Merge-on-Write implementation of
the Unique Key starting from version 2.0.
2. Starting from version 2.0.2, partial updates are supported using INSERT
INTO.
+3. Partial updates are not supported on tables with materialized views.
:::
### Use Cases
@@ -138,8 +139,6 @@ After the update, the result is as follows:
1 row in set (0.01 sec)
```
-Partial Column Updates in the Primary Key Model
-
### Notes
Due to the Merge-on-Write implementation requiring data completion during data
writing to ensure optimal query performance, performing partial column updates
using the Merge-on-Write implementation may result in a decrease in load
performance.
diff --git
a/versioned_docs/version-3.0/data-operate/update/update-of-unique-model.md
b/versioned_docs/version-3.0/data-operate/update/update-of-unique-model.md
index fd4d787d21c..d5090219e20 100644
--- a/versioned_docs/version-3.0/data-operate/update/update-of-unique-model.md
+++ b/versioned_docs/version-3.0/data-operate/update/update-of-unique-model.md
@@ -39,6 +39,7 @@ Note:
1. Partial updates are only supported in the Merge-on-Write implementation of
the Unique Key starting from version 2.0.
2. Starting from version 2.0.2, partial updates are supported using INSERT
INTO.
+3. Partial updates are not supported on tables with materialized views.
:::
### Use Cases
@@ -138,8 +139,6 @@ After the update, the result is as follows:
1 row in set (0.01 sec)
```
-Partial Column Updates in the Primary Key Model
-
### Notes
Due to the Merge-on-Write implementation requiring data completion during data
writing to ensure optimal query performance, performing partial column updates
using the Merge-on-Write implementation may result in a decrease in load
performance.
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
