This is an automated email from the ASF dual-hosted git repository.
luzhijing 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 b11a09f77fc Add enable_mow_light_delete property (#826)
b11a09f77fc is described below
commit b11a09f77fc630639ba5572e6e9271dde06dff73
Author: abmdocrt <yukang.lian2...@gmail.com>
AuthorDate: Mon Jul 8 21:22:20 2024 +0800
Add enable_mow_light_delete property (#826)
Co-authored-by: Luzhijing <82810928+luzhij...@users.noreply.github.com>
---
.../Data-Definition-Statements/Create/CREATE-TABLE.md | 9 +++++++++
.../Data-Definition-Statements/Create/CREATE-TABLE.md | 10 ++++++++++
.../Data-Definition-Statements/Create/CREATE-TABLE.md | 10 ++++++++++
.../Data-Definition-Statements/Create/CREATE-TABLE.md | 9 +++++++++
4 files changed, 38 insertions(+)
diff --git
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
index f38828ff75e..42089cd4747 100644
---
a/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/docs/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -477,6 +477,15 @@ Set table properties. The following attributes are
currently supported:
`"time_series_compaction_time_threshold_seconds" = "3600"`
+* `enable_mow_light_delete`
+
+ If modify delete predicate for the DELETE statement on the unique
merge-on-write table. If enabled, it will improve the performance of the DELETE
statement, but errors may occur in partial column updates after deletion. If
disabled, it will reduce the performance of the DELETE statement to ensure
correctness.
+
+ The default value for this property is false.
+
+ This propertiy can only be enabled on unique merge-on-write tables.
+
+ `"enable_mow_light_delete" = "true"`
* Dynamic partition related
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
index 774abcca212..cc1b584c610 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/current/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -470,6 +470,16 @@ UNIQUE KEY(k1, k2)
`"time_series_compaction_level_threshold" = "2"`
+* `enable_mow_light_delete`
+
+ 是否在 Unique 表 Mow 上开启 Delete 语句写 Delete predicate。若开启，会提升 Delete 语句的性能，但
Delete 后进行部分列更新可能会出现部分数据错误的情况。若关闭，会降低 Delete 语句的性能来保证正确性。
+
+ 此属性的默认值为 `false`。
+
+ 此属性只能在 Unique Merge-on-Write表上开启。
+
+ `"enable_mow_light_delete" = "true"`
+
* 动态分区相关
动态分区相关参数如下：
diff --git
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
index 1218eb08e80..d99323d0c5b 100644
---
a/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/i18n/zh-CN/docusaurus-plugin-content-docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -464,6 +464,16 @@ UNIQUE KEY(k1, k2)
`"time_series_compaction_level_threshold" = "2"`
+* `enable_mow_light_delete`
+
+ 是否在 Unique 表 Mow 上开启 Delete 语句写 Delete predicate。若开启，会提升 Delete 语句的性能，但
Delete 后进行部分列更新可能会出现部分数据错误的情况。若关闭，会降低 Delete 语句的性能来保证正确性。
+
+ 此属性的默认值为 `false`。
+
+ 此属性只能在 Unique Merge-on-Write表上开启。
+
+ `"enable_mow_light_delete" = "true"`
+
* 动态分区相关
动态分区相关参数如下：
diff --git
a/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
b/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
index 88269d51d26..e6140f8ca40 100644
---
a/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
+++
b/versioned_docs/version-2.1/sql-manual/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
@@ -477,6 +477,15 @@ Set table properties. The following attributes are
currently supported:
`"time_series_compaction_time_threshold_seconds" = "3600"`
+* `enable_mow_light_delete`
+
+ If modify delete predicate for the DELETE statement on the unique
merge-on-write table. If enabled, it will improve the performance of the DELETE
statement, but errors may occur in partial column updates after deletion. If
disabled, it will reduce the performance of the DELETE statement to ensure
correctness.
+
+ The default value for this property is false.
+
+ This propertiy can only be enabled on unique merge-on-write tables.
+
+ `"enable_mow_light_delete" = "true"`
* Dynamic partition related
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
