[
https://issues.apache.org/jira/browse/FLINK-27237?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
dalongliu updated FLINK-27237:
------------------------------
Description:
This is an umbrella issue which is used to track the syntax enhancement about
partitioned table. 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> ...] } [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/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]
was:
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]
> 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 track the syntax enhancement about
> partitioned table. 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> ...] } [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/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.1#820001)
