dataroaring commented on code in PR #13872:
URL: https://github.com/apache/doris/pull/13872#discussion_r1011384252
##########
docs/zh-CN/docs/data-operate/update-delete/sequence-column-manual.md:
##########
@@ -64,15 +64,24 @@ Sequence列建表时在property中增加了一个属性，用来标识`__DORIS_S
**建表**
-创建Uniq表时，可以指定sequence列类型
+方法一：创建Uniq表时，可以指定sequence列类型。
```text
PROPERTIES (
"function_column.sequence_type" = 'Date',
);
```
-sequence_type用来指定sequence列的类型，可以为整型和时间类型（DATE、DATETIME）。
+sequence_type用来指定sequence列的类型，可以为整型和时间类型（DATE、DATETIME）。导入时需要指定映射列。
+
+方法二：创建Uniq表时，可以指定sequence列到其他column的映射。
+
+```text
+PROPERTIES (
+ "function_column.sequence_col" = 'column_name',
+);
+```
+sequence_col用来指定sequence列到其他column的映射，该列可以为整型和时间类型（DATE、DATETIME），创建后不能更改该列的类型。导入时不用再指定映射列。
Review Comment:
Refer to comment in en doc.
##########
docs/en/docs/data-operate/update-delete/sequence-column-manual.md:
##########
@@ -60,13 +60,21 @@ The principle is the same as the reading process during
Base Compaction.
When the Sequence column creates a table, an attribute is added to the
property, which is used to identify the type import of
`__DORIS_SEQUENCE_COL__`. The grammar design is mainly to add a mapping from
the sequence column to other columns. The settings of each seed method will be
described below introduce.
#### Create Table
-When you create the Uniq table, you can specify the sequence column type.
+1. When you create the Uniq table, you can specify the sequence column type.
```text
PROPERTIES (
"function_column.sequence_type" = 'Date',
);
```
-The sequence_type is used to specify the type of the sequence column, which
can be integral and time (DATE / DATETIME).
+The sequence_type is used to specify the type of the sequence column, which
can be integral and time (DATE / DATETIME). The mapping column needs to be
specified when importing.
+
+2. When you create the Uniq table, you can specify the mapping of sequence
column to other columns.
+```text
+PROPERTIES (
+ "function_column.sequence_col" = 'column_name',
+);
+```
+The sequence_col is used to specify the mapping of the sequence column to
other columns, which can be integral and time (DATE, DATETIME). The type of
this column cannot be changed after creation. You no longer need to specify
mapping column when importing.
Review Comment:
If function_column.sequence_col is set, function_column.sequence_type is
ignored.
##########
docs/en/docs/data-operate/update-delete/sequence-column-manual.md:
##########
@@ -60,13 +60,21 @@ The principle is the same as the reading process during
Base Compaction.
When the Sequence column creates a table, an attribute is added to the
property, which is used to identify the type import of
`__DORIS_SEQUENCE_COL__`. The grammar design is mainly to add a mapping from
the sequence column to other columns. The settings of each seed method will be
described below introduce.
#### Create Table
-When you create the Uniq table, you can specify the sequence column type.
+1. When you create the Uniq table, you can specify the sequence column type.
```text
PROPERTIES (
"function_column.sequence_type" = 'Date',
);
```
-The sequence_type is used to specify the type of the sequence column, which
can be integral and time (DATE / DATETIME).
+The sequence_type is used to specify the type of the sequence column, which
can be integral and time (DATE / DATETIME). The mapping column needs to be
specified when importing.
+
+2. When you create the Uniq table, you can specify the mapping of sequence
column to other columns.
Review Comment:
Put this method as the 1st one.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org
For additional commands, e-mail: commits-h...@doris.apache.org
