This is an automated email from the ASF dual-hosted git repository.
xushiyan pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/hudi.git
The following commit(s) were added to refs/heads/asf-site by this push:
new baeecb45db9 [HUDI-6331][DOCS] Update user doc of partial insert in
MERGE INTO command (#10952)
baeecb45db9 is described below
commit baeecb45db9174f35c1cfa741f751ef50984d9fa
Author: Jing Zhang <[email protected]>
AuthorDate: Tue Apr 2 23:19:39 2024 +0800
[HUDI-6331][DOCS] Update user doc of partial insert in MERGE INTO command
(#10952)
---
website/docs/sql_dml.md | 7 +++++++
1 file changed, 7 insertions(+)
diff --git a/website/docs/sql_dml.md b/website/docs/sql_dml.md
index e6765af0bc5..90576dcb0e0 100644
--- a/website/docs/sql_dml.md
+++ b/website/docs/sql_dml.md
@@ -122,6 +122,13 @@ ON <merge_condition>
INSERT (column1 [, column2 ...]) VALUES (value1 [, value2 ...])
```
+:::info
+`WHEN NOT MATCHED` clauses specify the action to perform if the values do not
match.
+There are two kinds of `INSERT` clauses:
+1. `INSERT *` clauses require that the source table has the same columns as
those in the target table.
+2. `INSERT (column1 [, column2 ...]) VALUES (value1 [, value2 ...])` clauses
do not require to specify all the columns of the target table. For unspecified
target columns, insert the `NULL` value.
+:::
+
Examples below
```sql
