ALTER TABLE RENAME PARTITION - Amazon Athena

ALTER TABLE RENAME PARTITION

Renames a partition column, partition_spec, for the table named table_name, to new_partition_spec.

For information about partitioning, see Partitioning data in Athena.

Synopsis

ALTER TABLE table_name PARTITION (partition_spec) RENAME TO PARTITION (new_partition_spec)

Parameters

PARTITION (partition_spec)

Each partition_spec specifies a column name/value combination in the form partition_col_name = partition_col_value [,...].

Examples

ALTER TABLE orders PARTITION (dt = '2014-05-14', country = 'IN') RENAME TO PARTITION (dt = '2014-05-15', country = 'IN');