[jira] [Created] (FLINK-21026) Align column list specification with Hive in INSERT statement

[Shang Yuanchun (Jira)]

Zhenghua Gao created FLINK-21026:
------------------------------------

             Summary: Align column list specification with Hive in INSERT statement
                 Key: FLINK-21026
                 URL: https://issues.apache.org/jira/browse/FLINK-21026
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / API
            Reporter: Zhenghua Gao


[HIVE-9481|https://issues.apache.org/jira/browse/HIVE-9481] allows column list specification in INSERT statement. The syntax is:
{code:java}
INSERT INTO TABLE table_name 
[PARTITION (partcol1[=val1], partcol2[=val2] ...)]
[(column list)] 
select_statement FROM from_statement
{code}
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[FLINK-18726|https://issues.apache.org/jira/browse/FLINK-18726].  I think it'a good change to align this with Hive now.

 
 



--
This message was sent by Atlassian Jira
(v8.3.4#803005)