[
https://issues.apache.org/jira/browse/FLINK-22408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17329983#comment-17329983
]
Ma Jun edited comment on FLINK-22408 at 4/23/21, 5:07 AM:
----------------------------------------------------------
I think the final Unparse result：
{code:java}
ALTER TABLE tbl DROP PARTITION (p1='a',p2=1), PARTITION (p1='b',p2=2);
{code}
was (Author: aidenma):
I think the final Unparse result：
{code:java}
alter table tbl drop partition (p1='a',p2=1), partition(p1='b',p2=2);
{code}
> 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: New Feature
> Components: Table SQL / API, Table SQL / Planner
> Affects Versions: 1.11.3
> Reporter: Ma Jun
> Priority: Major
> Labels: pull-request-available
>
> Flink Table Parser is error：
> *Synopsis:*
>
> *SQL：*
> {code:java}
> alter table tbl drop partition (p1='a',p2=1), partition(p1='b',p2=2);{code}
> *hive muit partition 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)
