You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Xintong Song (Jira)" <ji...@apache.org> on 2023/03/23 08:52:16 UTC
[jira] [Updated] (FLINK-27237) Partitioned table statement enhancement
[ https://issues.apache.org/jira/browse/FLINK-27237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Xintong Song updated FLINK-27237:
---------------------------------
Fix Version/s: 1.18.0
(was: 1.17.0)
> 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.18.0
>
>
> This is an umbrella issue which is used to track the syntax enhancement about partitioned table in FLIP [1]. These new syntaxes are very useful for partitioned tables, especially for batch job.
> The supported statement about partitioned table as follows:
> {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/FLINK/FLIP-63%3A+Rework+table+partition+support]
> [[2] https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterPartition|https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DDL#LanguageManualDDL-AlterPartition]
> [3]: [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]
> [4]: [https://spark.apache.org/docs/3.2.1/sql-ref-syntax-aux-show-partitions.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)