johanl-db commented on code in PR #56370:
URL: https://github.com/apache/spark/pull/56370#discussion_r3381711001
##########
docs/sql-ref-syntax-dml-insert-table.md:
##########
@@ -55,6 +61,11 @@ INSERT INTO [ TABLE ] table_identifier REPLACE WHERE
boolean_expression query
- All specified columns should exist in the table and not be duplicated
from each other. It includes all columns except the static partition columns.
- The size of the column list should be exactly the size of the data from
`VALUES` clause or query.
+* **BY NAME**
+
+ Columns and nested fields are matched by position between the source query
and the target
+ table, unless `BY NAME` is specified, in which case columns and fields are
matched by name.
Review Comment:
```suggestion
By default, columns and nested fields are matched by position between
the source query and the target
table. With `BY NAME`, columns and nested fields are matched by name,
allowing them to be ordered differently in the source query and target table.
```
--
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]
