[ https://issues.apache.org/jira/browse/FLINK-27237?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17522755#comment-17522755 ]
dalongliu commented on FLINK-27237: ----------------------------------- We have discussed and voted this ticket in [FLIP-63|[https://cwiki.apache.org/confluence/display/FLINK/FLIP-63%3A+Rework+table+partition+support].] So it is the continuation of FLIP-63. > 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> ...] } [PURGE] > -- 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)