ALTER TABLE RENAME PARTITION - Amazon Athena
SynopsisParametersExamplesRenaming a partition column in Amazon GlueAdditional resources
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

ALTER TABLE RENAME PARTITION

Renames a partition value.

Note

ALTER TABLE RENAME PARTITION does not rename partition columns. To change a partition column name, you can use the Amazon Glue console. For more information, see Renaming a partition column in Amazon Glue later in this document.

Synopsis

For the table named table_name, renames the partition value specified by partition_spec to the value specified by new_partition_spec.

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');

Renaming a partition column in Amazon Glue

Use the following procedure to rename partition column names in the Amazon Glue console.

To rename a table partition column in the Amazon Glue console

  1. Sign in to the Amazon Web Services Management Console and open the Amazon Glue console at https://console.amazonaws.cn/glue/.

  2. In the navigation pane, choose Tables.

  3. On the Tables page, use the Filter tables search box to find the table that you want to change.

  4. In the Name column, choose the link of the table that you want to change.

  5. On the details page for the table, in the Schema section, do one of the following:

    • To make the name change in JSON format, choose Edit schema as JSON.

    • To change the name directly, choose Edit schema. This procedure chooses Edit schema.

  6. Select the check box for the partitioned column that you want to rename, and then choose Edit.

  7. In the Edit schema entry dialog box, for Name, enter the new name for the partition column.

  8. Choose Save as new table version. This action updates the partition column name and preserves the schema evolution history without creating a separate physical copy of your data.

  9. To compare table versions, on the details page for the table, choose Actions, and then choose Compare versions.

Additional resources

For more information about partitioning, see Partitioning data in Athena.