[jira] [Comment Edited] (FLINK-27237) Partitioned table statement enhancement

["dalongliu (Jira)" <ji...@apache.org>]

    [ 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)