[ https://issues.apache.org/jira/browse/FLINK-27237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17522702#comment-17522702 ]
dalongliu edited comment on FLINK-27237 at 4/15/22 7:20 AM: ------------------------------------------------------------ Yes, I agree with you. I have opened a [thread|https://lists.apache.org/thread/cl2876ytgyvyb0j12m7wtlvm1hsfjgmy] about this issue in dev mailing list . Since these added syntaxes will not introduce new public API, I don't think we need a FLIP and we can finish the discussion on this issue. was (Author: lsy): Yes, I agree with you. I will have opened a [thread|https://lists.apache.org/thread/cl2876ytgyvyb0j12m7wtlvm1hsfjgmy] about this issue in dev mailing list . Since these added syntaxes will not introduce new public API, I don't think we need a FLIP and we can finish the discussion on this issue. > Partitioned table statement enhancement > --------------------------------------- > > Key: FLINK-27237 > URL: https://issues.apache.org/jira/browse/FLINK-27237 > Project: Flink > Issue Type: New Feature > Components: Table SQL / API > Reporter: dalongliu > Priority: Major > Fix For: 1.16.0 > > > This is an umbrella issue which is used to discuss the syntax enhancement > about partitioned table. These new syntaxes are very useful for partitioned > tables, especially for batch job. > Therefore, I propose to support the following statement about partitioned > table: > {code:sql} > -- add partition > ALTER TABLE table_name ADD [IF NOT EXISTS] { PARTITION <partition_spec> > [PARTITION <partition_spec> ...] } > -- drop partition > ALTER TABLE table_name DROP [ IF EXISTS ] { PARTITION <partition_spec> > [PARTITION <partition_spec> ...] } > -- rename partition > ALTER TABLE table_name PARTITION <partition_spec> RENAME TO PARTITION > <partition_spec>; > -- show partitions > SHOW PARTITIONS table_name [PARTITION <partition_spec>] > <partition_spec>:: > (partition_col_name=partition_col_val, ...) > {code} > > Reference: > [1]: > [https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterPartition] > [2]: > [https://spark.apache.org/docs/3.2.1/sql-ref-syntax-ddl-alter-table.html#add-partition|https://spark.apache.org/docs/3.0.0/sql-ref-syntax-ddl-alter-table.html#add-partition] > [3]: > https://spark.apache.org/docs/3.2.1/sql-ref-syntax-aux-show-partitions.html -- This message was sent by Atlassian Jira (v8.20.1#820001)