[
https://issues.apache.org/jira/browse/FLINK-22408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17330010#comment-17330010
]
Rui Li commented on FLINK-22408:
--------------------------------
Hi [~jark], the feature is already supported:
https://ci.apache.org/projects/flink/flink-docs-release-1.12/dev/table/connectors/hive/hive_dialect.html#drop-partitions
The issue here is the unparse result of the SqlNode is incorrect.
> 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)
