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 72799622e1 [typo](docs) Supplementary explanation on the hint section
of insertSupplementary explanation on the hint section of INSERT.md (#19171)
72799622e1 is described below
commit 72799622e169e42fcc0f0da0d175433ab4470c2a
Author: yagagagaga <[email protected]>
AuthorDate: Thu Apr 27 23:21:01 2023 +0800
[typo](docs) Supplementary explanation on the hint section of
insertSupplementary explanation on the hint section of INSERT.md (#19171)
---
.../Data-Manipulation-Statements/Manipulation/INSERT.md | 6 ++++--
.../Data-Manipulation-Statements/Manipulation/INSERT.md | 6 ++++--
2 files changed, 8 insertions(+), 4 deletions(-)
diff --git
a/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/INSERT.md
b/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/INSERT.md
index 8b9fbc4690..6025aa791b 100644
---
a/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/INSERT.md
+++
b/docs/en/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/INSERT.md
@@ -59,8 +59,10 @@ INSERT INTO table_name
>
> query: a common query, the result of the query will be written to the target
>
-> hint: some indicator used to indicate the execution behavior of `INSERT`.
Both `streaming` and the default non-`streaming` method use synchronous mode to
complete `INSERT` statement execution
-> The non-`streaming` method will return a label after the execution is
completed, which is convenient for users to query the import status through
`SHOW LOAD`
+> hint: some indicator used to indicate the execution behavior of `INSERT`.
You can choose one of this values: `/*+ STREAMING */`, `/*+ SHUFFLE */` or `/*+
NOSHUFFLE */.
+> 1. STREAMING: At present, it has no practical effect and is only reserved
for compatibility with previous versions. (In the previous version, adding this
hint would return a label, but now it defaults to returning a label)
+> 2. SHUFFLE: When the target table is a partition table, enabling this hint
will do repartiiton.
+> 3. NOSHUFFLE: Even if the target table is a partition table, repartiiton
will not be performed, but some other operations will be performed to ensure
that the data is correctly dropped into each partition.
Notice:
diff --git
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/INSERT.md
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/INSERT.md
index 6dced610ba..8a8acfb65d 100644
---
a/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/INSERT.md
+++
b/docs/zh-CN/docs/sql-manual/sql-reference/Data-Manipulation-Statements/Manipulation/INSERT.md
@@ -59,8 +59,10 @@ INSERT INTO table_name
>
> query: 一个普通查询，查询的结果会写入到目标中
>
-> hint: 用于指示 `INSERT` 执行行为的一些指示符。`streaming` 和 默认的非 `streaming` 方式均会使用同步方式完成
`INSERT` 语句执行
-> 非 `streaming` 方式在执行完成后会返回一个 label 方便用户通过 `SHOW LOAD` 查询导入的状态
+> hint: 用于指示 `INSERT` 执行行为的一些指示符。目前 hint 有三个可选值`/*+ STREAMING */`、`/*+ SHUFFLE
*/`或`/*+ NOSHUFFLE */`
+> 1. STREAMING：目前无实际作用，只是为了兼容之前的版本，因此保留。（之前的版本加上这个 hint 会返回 label，现在默认都会返回
label）
+> 2. SHUFFLE：当目标表是分区表，开启这个 hint 会进行 repartiiton。
+> 3. NOSHUFFLE：即使目标表是分区表，也不会进行 repartiiton，但会做一些其他操作以保证数据正确落到各个分区中。
注意：
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
