[SPARK-17693] Fixed Insert Failure To Data Source Tables when the Schema has the Comment Field

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0.0, 2.1.0
• Fix Version/s: 2.0.3, 2.1.0
• Component/s: SQL
• Assignee: Xiao Li
• Reporter: Xiao Li
• Created: 27/Sep/16 18:32
• Updated: 05/Nov/16 10:46
• Resolved: 26/Oct/16 07:39

Description

CREATE TABLE tab1(col1 int COMMENT 'a', col2 int) USING parquet
INSERT INTO TABLE tab1 SELECT 1, 2

The insert attempt will fail if the target table has a column with comments. The error is strange to the external users:

assertion failed: No plan for InsertIntoTable Relation[col1#15,col2#16] parquet, false, false
+- Project [1 AS col1#19, 2 AS col2#20]
   +- OneRowRelation$

Issue Links

• links to: [Github] Pull Request #15266 (gatorsmile)
• links to: [Github] Pull Request #15615 (gatorsmile)
• links to: [Github] Pull Request #15782 (gatorsmile)