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.git
The following commit(s) were added to refs/heads/master by this push:
new ff8902370c [improvement](doc) Supplementary Bulk Deletion Notes
(#17113)
ff8902370c is described below
commit ff8902370c59dd11bb9abf6cdd47043abd66d76c
Author: yadao <[email protected]>
AuthorDate: Wed Mar 1 13:35:20 2023 +0800
[improvement](doc) Supplementary Bulk Deletion Notes (#17113)
* 补充批量删除注意事项
* 按照批量删除文档前文的介绍, 用户可能会开启`show_hidden_columns`的session variable来查看表是否支持批量删除.
* 后续按示例进行DELETE/MERGE的导入作业后, 如果在同一个session中执行`select count(*) from xxx`语句时,
可能会发现结果与预期不一致
* 可能无法快速联想到是因为之前开启的session variable导致被删除的语句也被查出来了.
* supplement batch deletion notes for English doc
---
docs/en/docs/data-operate/update-delete/batch-delete-manual.md | 1 +
docs/zh-CN/docs/data-operate/update-delete/batch-delete-manual.md | 1 +
2 files changed, 2 insertions(+)
diff --git a/docs/en/docs/data-operate/update-delete/batch-delete-manual.md
b/docs/en/docs/data-operate/update-delete/batch-delete-manual.md
index 1ccd6e21f7..1a72eadcbc 100644
--- a/docs/en/docs/data-operate/update-delete/batch-delete-manual.md
+++ b/docs/en/docs/data-operate/update-delete/batch-delete-manual.md
@@ -133,6 +133,7 @@ The writing method of `Routine Load` adds a mapping to the
`columns` field. The
## Note
1. Since import operations other than stream load may be executed out of order
inside doris, if it is not stream load when importing using the `MERGE` method,
it needs to be used with load sequence. For the specific syntax, please refer
to the [sequence](sequence-column-manual.md) column related documents
2. `DELETE ON` condition can only be used with MERGE.
+3. if session variable `SET show_hidden_columns = true` was executed before
running import task to show whether table support batch delete feature, then
execute `select count(*) from xxx` statement in the same session after
finishing `DELETE/MERGE` import task, it will result in a unexpected result
that the statement result set will include the deleted results. To avoid this
problem you should execute `SET show_hidden_columns = false` before select
statement or open a new session to run [...]
## Usage example
diff --git a/docs/zh-CN/docs/data-operate/update-delete/batch-delete-manual.md
b/docs/zh-CN/docs/data-operate/update-delete/batch-delete-manual.md
index 44331ae31c..efa68c33be 100644
--- a/docs/zh-CN/docs/data-operate/update-delete/batch-delete-manual.md
+++ b/docs/zh-CN/docs/data-operate/update-delete/batch-delete-manual.md
@@ -133,6 +133,7 @@ CREATE ROUTINE LOAD example_db.test1 ON example_tbl
1. 由于除`Stream Load` 外的导入操作在doris 内部有可能乱序执行，因此在使用`MERGE` 方式导入时如果不是`Stream
Load`，需要与 load sequence 一起使用，具体的 语法可以参照[`sequence`](sequence-column-manual.md)列
相关的文档；
2. `DELETE ON` 条件只能与 MERGE 一起使用。
+3. 如果在执行导入作业前按上文所述开启了`SET show_hidden_columns = true`的session
variable来查看表是否支持批量删除, 按示例完成DELETE/MERGE的导入作业后, 如果在同一个session中执行`select count(*)
from xxx`等语句时, 需要执行`SET show_hidden_columns = false`或者开启新的session,
避免查询结果中包含那些被批量删除的记录, 导致结果与预期不符.
## 使用示例
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
