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