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 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]
