Jose Torres created SPARK-42750:
-----------------------------------
Summary: Support INSERT INTO by name
Key: SPARK-42750
URL: https://issues.apache.org/jira/browse/SPARK-42750
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 3.4.0
Reporter: Jose Torres
In some use cases, users have incoming dataframes with fixed column names which
might differ from the canonical order. Currently there's no way to handle this
easily through the INSERT INTO API - the user has to make sure the columns are
in the right order as they would when inserting a tuple. We should add an
optional BY NAME clause, such that:
INSERT INTO tgt BY NAME <query>
takes each column of <query> and inserts it into the column in `tgt` which has
the same name according to the configured `resolver` logic.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@spark.apache.org
For additional commands, e-mail: issues-h...@spark.apache.org
