Help Center/ Data Lake Insight/ SQL Syntax Reference (To Be Offline)/ Spark SQL Syntax Reference (Unavailable Soon)/ Syntax for Partitioning a Table/ Renaming a Partition (Only OBS Tables Supported)
Updated on 2024-11-08 GMT+08:00
View PDF
Share

Renaming a Partition (Only OBS Tables Supported)

Function

This statement is used to rename partitions.

Syntax

1
2
3
 
ALTER TABLE table_name
  PARTITION partition_specs
  RENAME TO PARTITION partition_specs;

Keywords

  • PARTITION: a specified partition
  • RENAME: new name of the partition

Parameters

Table 1 Parameters

Parameter

Description

table_name

Table name

partition_specs

Partition fields

Precautions

  • This statement is used for OBS table operations.
  • The table and partition to be renamed must exist. Otherwise, an error occurs. The name of the new partition must be unique. Otherwise, an error occurs.
  • If a table is partitioned using multiple fields, you are required to specify all the fields of a partition (at random order) when renaming the partition.
  • By default, the partition_specs parameter contains (). For example: PARTITION (dt='2009-09-09',city='xxx')

Example

To modify the name of the city='xxx',dt='2008-08-08' partition in the student table to city='xxx',dt='2009-09-09', run the following statement:

1
2
3
 
ALTER TABLE student
  PARTITION (city='xxx',dt='2008-08-08')
  RENAME TO PARTITION (city='xxx',dt='2009-09-09');