[jira] [Created] (FLINK-22408) Flink Table Parsr Hive Drop Partitions Syntax unparse is Error

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

[jira] [Created] (FLINK-22408) Flink Table Parsr Hive Drop Partitions Syntax unparse is Error

Shang Yuanchun (Jira)
Ma Jun created FLINK-22408:
------------------------------

             Summary: Flink Table Parsr Hive Drop Partitions Syntax unparse is Error
                 Key: FLINK-22408
                 URL: https://issues.apache.org/jira/browse/FLINK-22408
             Project: Flink
          Issue Type: Bug
          Components: Table SQL / API, Table SQL / Planner
    Affects Versions: 1.11.3
            Reporter: Ma Jun


Flink Table Parser is error:

*Synopsis:*

 

*SQL:*
{code:java}
alter table tbl drop partition (p1='a',p2=1), partition(p1='b',p2=2);{code}
*unparse toSqlString is :*
{code:java}
ALTER TABLE `TBL`\n" +
      "DROP\n" +
      "PARTITION (`P1` = 'a', `P2` = 1)\n" +
      "PARTITION (`P1` = 'b', `P2` = 2)
{code}
Missing comma in Partition SqlNodeList 

 Hive syntax:
{code:java}
ALTER TABLE table_name DROP [IF EXISTS] PARTITION (partition_spec) [, PARTITION (partition_spec)];
{code}
 



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