yangzhg commented on a change in pull request #6817:
URL: https://github.com/apache/incubator-doris/pull/6817#discussion_r727674896
##########
File path: docs/en/sql-reference/sql-statements/Data Definition/CREATE TABLE.md
##########
@@ -91,7 +91,7 @@ Syntax:
* SUM、MAX、MIN、REPLACE
* HLL_UNION: Only for HLL type
- * REPLACE_IF_NOT_NULL: The meaning of this aggregation type is that
substitution will occur if and only if the newly imported data is a non-null
value. If the newly imported data is null, Doris will still retain the original
value. Note: if NOT NULL is specified in the REPLACE_IF_NOT_NULL column when
the user creates the table, Doris will convert it to NULL and will not report
an error to the user. Users can leverage this aggregate type to achieve
importing some of columns.
+ * REPLACE_IF_NOT_NULL: The meaning of this aggregation type is that
substitution will occur if and only if the newly imported data is a non-null
value. If the newly imported data is null, Doris will still retain the original
value. Note: if NOT NULL is specified in the REPLACE_IF_NOT_NULL column when
the user creates the table, Doris will convert it to NULL and will not report
an error to the user. Users can leverage this aggregate type to achieve
importing some of columns . **It should be noted here that the default value
should be NULL, not a nullable string. If it is an empty string, you should
replace it with an empty string**.
Review comment:
```suggestion
* REPLACE_IF_NOT_NULL: The meaning of this aggregation type is that
substitution will occur if and only if the newly imported data is a non-null
value. If the newly imported data is null, Doris will still retain the original
value. Note: if NOT NULL is specified in the REPLACE_IF_NOT_NULL column when
the user creates the table, Doris will convert it to NULL and will not report
an error to the user. Users can leverage this aggregate type to achieve
importing some of columns . **It should be noted here that the default value
should be NULL, not a empty string. If it is an empty string, you should
replace it with an empty string**.
```
##########
File path:
docs/zh-CN/sql-reference-v2/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
##########
@@ -108,11 +108,12 @@ distribution_info
MIN：求最小值。适合数值类型。
MAX：求最大值。适合数值类型。
REPLACE：替换。对于维度列相同的行，指标列会按照导入的先后顺序，后倒入的替换先导入的。
- REPLACE_IF_NOT_NULL：非空值替换。和 REPLACE 的区别在于对于null值，不做替换。
+ REPLACE_IF_NOT_NULL：非空值替换。和 REPLACE
的区别在于对于null值，不做替换。这里要注意的是字段默认值要给NULL，而不是能空字符串，如果是空字符串，会给你替换成空字符串
Review comment:
```suggestion
REPLACE_IF_NOT_NULL：非空值替换。和 REPLACE
的区别在于对于null值，不做替换。这里要注意的是字段默认值要给NULL，而不能是空字符串，如果是空字符串，会给你替换成空字符串
```
##########
File path: docs/zh-CN/sql-reference/sql-statements/Data Definition/CREATE
TABLE.md
##########
@@ -94,7 +94,7 @@ under the License.
* SUM、MAX、MIN、REPLACE
* HLL_UNION(仅用于HLL列，为HLL独有的聚合方式)、
* BITMAP_UNION(仅用于 BITMAP 列，为 BITMAP 独有的聚合方式)、
- *
REPLACE_IF_NOT_NULL：这个聚合类型的含义是当且仅当新导入数据是非NULL值时会发生替换行为，如果新导入的数据是NULL，那么Doris仍然会保留原值。注意：如果用在建表时REPLACE_IF_NOT_NULL列指定了NOT
NULL，那么Doris仍然会将其转化NULL，不会向用户报错。用户可以借助这个类型完成部分列导入的功能。
+ *
REPLACE_IF_NOT_NULL：这个聚合类型的含义是当且仅当新导入数据是非NULL值时会发生替换行为，如果新导入的数据是NULL，那么Doris仍然会保留原值。注意：如果用在建表时REPLACE_IF_NOT_NULL列指定了NOT
NULL，那么Doris仍然会将其转化NULL，不会向用户报错。用户可以借助这个类型完成部分列导入的功能。**这里要注意的是字段默认值要给NULL，而不是能空字符串，如果是空字符串，会给你替换成空字符串**
Review comment:
```suggestion
*
REPLACE_IF_NOT_NULL：这个聚合类型的含义是当且仅当新导入数据是非NULL值时会发生替换行为，如果新导入的数据是NULL，那么Doris仍然会保留原值。注意：如果用在建表时REPLACE_IF_NOT_NULL列指定了NOT
NULL，那么Doris仍然会将其转化NULL，不会向用户报错。用户可以借助这个类型完成部分列导入的功能。**这里要注意的是字段默认值要给NULL，而不能是空字符串，如果是空字符串，会给你替换成空字符串**
```
##########
File path:
docs/en/sql-reference-v2/sql-statements/Data-Definition-Statements/Create/CREATE-TABLE.md
##########
@@ -108,7 +108,7 @@ distribution_info
MIN: Find the minimum value. Suitable for numeric types.
MAX: Find the maximum value. Suitable for numeric types.
REPLACE: Replace. For rows with the same dimension column, the
index column will be imported in the order of import, and the last imported
will replace the first imported.
- REPLACE_IF_NOT_NULL: non-null value replacement. The difference
with REPLACE is that there is no replacement for null values.
+ REPLACE_IF_NOT_NULL: non-null value replacement. The difference
with REPLACE is that there is no replacement for null values. It should be
noted here that the default value should be NULL, not a nullable string. If it
is an empty string, you should replace it with an empty string
Review comment:
```suggestion
REPLACE_IF_NOT_NULL: non-null value replacement. The difference
with REPLACE is that there is no replacement for null values. It should be
noted here that the default value should be NULL, not an empty string. If it is
an empty string, you should replace it with an empty string
```
##########
File path: docs/en/sql-reference/sql-statements/Data Definition/CREATE TABLE.md
##########
@@ -91,7 +91,7 @@ Syntax:
* SUM、MAX、MIN、REPLACE
* HLL_UNION: Only for HLL type
- * REPLACE_IF_NOT_NULL: The meaning of this aggregation type is that
substitution will occur if and only if the newly imported data is a non-null
value. If the newly imported data is null, Doris will still retain the original
value. Note: if NOT NULL is specified in the REPLACE_IF_NOT_NULL column when
the user creates the table, Doris will convert it to NULL and will not report
an error to the user. Users can leverage this aggregate type to achieve
importing some of columns.
+ * REPLACE_IF_NOT_NULL: The meaning of this aggregation type is that
substitution will occur if and only if the newly imported data is a non-null
value. If the newly imported data is null, Doris will still retain the original
value. Note: if NOT NULL is specified in the REPLACE_IF_NOT_NULL column when
the user creates the table, Doris will convert it to NULL and will not report
an error to the user. Users can leverage this aggregate type to achieve
importing some of columns . **It should be noted here that the default value
should be NULL, not a nullable string. If it is an empty string, you should
replace it with an empty string**.
Review comment:
```suggestion
* REPLACE_IF_NOT_NULL: The meaning of this aggregation type is that
substitution will occur if and only if the newly imported data is a non-null
value. If the newly imported data is null, Doris will still retain the original
value. Note: if NOT NULL is specified in the REPLACE_IF_NOT_NULL column when
the user creates the table, Doris will convert it to NULL and will not report
an error to the user. Users can leverage this aggregate type to achieve
importing some of columns . **It should be noted here that the default value
should be NULL, not an empty string. If it is an empty string, you should
replace it with an empty string**.
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
