[
https://issues.apache.org/jira/browse/FLINK-22408?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17332910#comment-17332910
]
Ma Jun commented on FLINK-22408:
--------------------------------
Hi [~lirui] Thank！I got it! I know that if there is a subsequent release of
version 1.13, I will switch the version of the existing business. I have a
business requirement here: I use the module SQL translation in Flink to do some
front-end SQL verification and formatting, because I found that the syntax of
hive is inconsistent when converting dialects. So I think we should keep the
syntax consistent with hive.
> 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: Connectors / Hive
> 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)
