Serge Rielau created SPARK-43438:
------------------------------------
Summary: Fix mismatched column list error on INSERT
Key: SPARK-43438
URL: https://issues.apache.org/jira/browse/SPARK-43438
Project: Spark
Issue Type: Improvement
Components: Spark Core
Affects Versions: 3.4.0
Reporter: Serge Rielau
This error message is pretty bad, and common
"_LEGACY_ERROR_TEMP_1038" : {
"message" : [
"Cannot write to table due to mismatched user specified column
size(<columnSize>) and data column size(<outputSize>)."
]
},
It can perhaps be merged with this one - after giving it an ERROR_CLASS
"_LEGACY_ERROR_TEMP_1168" : {
"message" : [
"<tableName> requires that the data to be inserted have the same number of
columns as the target table: target table has <targetColumns> column(s) but the
inserted data has <insertedColumns> column(s), including <staticPartCols>
partition column(s) having constant value(s)."
]
},
Repro:
CREATE TABLE tabtest(c1 INT, c2 INT);
INSERT INTO tabtest SELECT 1;
`spark_catalog`.`default`.`tabtest` requires that the data to be inserted have
the same number of columns as the target table: target table has 2 column(s)
but the inserted data has 1 column(s), including 0 partition column(s) having
constant value(s).
INSERT INTO tabtest(c1) SELECT 1, 2, 3;
Cannot write to table due to mismatched user specified column size(1) and data
column size(3).; line 1 pos 24
--
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
