[FLINK-21026] Align column list specification with Hive in INSERT statement

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.13.0
• Component/s: Table SQL / API
• Labels: pull-request-available
• Assignee: Zhenghua Gao
• Reporter: Zhenghua Gao
• Created: 19/Jan/21 08:57
• Updated: 28/May/21 08:06
• Resolved: 26/Jan/21 07:20

Description

HIVE-9481 allows column list specification in INSERT statement. The syntax is:

INSERT INTO TABLE table_name 
[PARTITION (partcol1[=val1], partcol2[=val2] ...)] 
[(column list)] 
select_statement FROM from_statement

In the MeanWhile, flink introduces PARTITION syntax that the PARTITION clause appears after the COLUMN LIST clause. It looks weird and luckily we don't support COLUMN LIST clause now.  I think it'a good chance to align this with Hive now.

 
 
 

Issue Links

• links to: GitHub Pull Request #14726