[FLINK-27237] Partitioned table statement enhancement

• Type: New Feature
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Fix Version/s: 2.0.0
• Component/s: Table SQL / API
• Assignee: Unassigned
• Reporter: dalongliu
• Created: 14/Apr/22 01:59
• Updated: 10/Jul/24 06:57

Description

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:

-- 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, ...)
 

 

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

[3]: https://spark.apache.org/docs/3.2.1/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

Issue Links

• is related to: FLINK-21634 ALTER TABLE statement enhancement
• is related to: FLINK-14249 Complete partition support for batch sql

Sub-Tasks

• Support ADD PARTITION statement for partitioned table: Closed
• Support DROP PARTITION statement for partitioned table: Resolved
• Support RENAME PARTITION statement for partitioned table: In Progress
• Support SHOW PARTITIONS statement for partitioned table: Resolved
• Support EXCHANGE PARTITION statement for partitioned table: Open
• Support DESC EXTENDED partition statement for partitioned table: Open
• Add doc for add/drop/show partition: Resolved