[
https://issues.apache.org/jira/browse/FLINK-22408?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Ma Jun updated FLINK-22408:
---------------------------
Description:
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}
was:
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}
> 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
> Priority: Major
>
> 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)
