You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@doris.apache.org by da...@apache.org on 2022/07/18 07:24:21 UTC
[doris] branch master updated: [doc] fix sequence_column_manual.md (#10907)
This is an automated email from the ASF dual-hosted git repository.
dataroaring 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 108e6207b1 [doc] fix sequence_column_manual.md (#10907)
108e6207b1 is described below
commit 108e6207b18d35448ccb13218e88c13b55f74927
Author: yixiutt <10...@users.noreply.github.com>
AuthorDate: Mon Jul 18 15:24:15 2022 +0800
[doc] fix sequence_column_manual.md (#10907)
Co-authored-by: yixiutt <yi...@selectdb.com>
---
docs/en/docs/data-operate/update-delete/sequence-column-manual.md | 6 +++---
.../zh-CN/docs/data-operate/update-delete/sequence-column-manual.md | 6 +++---
2 files changed, 6 insertions(+), 6 deletions(-)
diff --git a/docs/en/docs/data-operate/update-delete/sequence-column-manual.md b/docs/en/docs/data-operate/update-delete/sequence-column-manual.md
index a748c837bb..1c60b2ac45 100644
--- a/docs/en/docs/data-operate/update-delete/sequence-column-manual.md
+++ b/docs/en/docs/data-operate/update-delete/sequence-column-manual.md
@@ -209,10 +209,10 @@ MySQL [test]> select * from test_table;
+---------+------------+----------+-------------+---------+
| user_id | date | group_id | modify_date | keyword |
+---------+------------+----------+-------------+---------+
-| 1 | 2020-02-22 | 1 | 2020-02-23 | b |
+| 1 | 2020-02-22 | 1 | 2020-03-05 | c |
+---------+------------+----------+-------------+---------+
```
-In this import, the b is eventually retained in the keyword column because the value of the sequence column (the value in modify_date) is the maximum value: '2020-02-23'.
+In this import, the c is eventually retained in the keyword column because the value of the sequence column (the value in modify_date) in all imports is the maximum value: '2020-03-05'.
Try importing the following data again
```
@@ -228,5 +228,5 @@ MySQL [test]> select * from test_table;
| 1 | 2020-02-22 | 1 | 2020-03-23 | w |
+---------+------------+----------+-------------+---------+
```
-At this point, you can replace the original data in the table. To sum up, if the key is the same in the imported data of the same batch, the sequence column value will be compared. Select the record with the largest value to import into the Doris table,and the sequence column between different batches will not work.
+At this point, you can replace the original data in the table. To sum up, the sequence column will be compared among all the batches, the largest value of the same key will be imported into Doris table.
diff --git a/docs/zh-CN/docs/data-operate/update-delete/sequence-column-manual.md b/docs/zh-CN/docs/data-operate/update-delete/sequence-column-manual.md
index 23f568313f..fe06d02774 100644
--- a/docs/zh-CN/docs/data-operate/update-delete/sequence-column-manual.md
+++ b/docs/zh-CN/docs/data-operate/update-delete/sequence-column-manual.md
@@ -226,10 +226,10 @@ MySQL [test]> select * from test_table;
+---------+------------+----------+-------------+---------+
| user_id | date | group_id | modify_date | keyword |
+---------+------------+----------+-------------+---------+
-| 1 | 2020-02-22 | 1 | 2020-02-23 | b |
+| 1 | 2020-02-22 | 1 | 2020-03-05 | c |
+---------+------------+----------+-------------+---------+
```
-在这次导入的数据中，因sequence column的值（也就是modify_date中的值）中'22020-02-23'为最大值，所以keyword列中最终保留了b。
+在这次导入的数据中，会比较所有已导入数据的sequence column（也就是modify_date)，其中'2020-03-05'为最大值，所以keyword列中最终保留了c。
再尝试导入如下数据
@@ -249,7 +249,7 @@ MySQL [test]> select * from test_table;
+---------+------------+----------+-------------+---------+
```
-此时就可以替换表中原有的数据。综上，在同批次导入数据中key相同会比较sequence列值，选择值最大的记录导入Doris表中，不同批次之间sequence列不起作用。
+此时就可以替换表中原有的数据。综上，在导入过程中，会比较所有批次的sequence列值，选择值最大的记录导入Doris表中。
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@doris.apache.org
For additional commands, e-mail: commits-help@doris.apache.org