ALTER TABLE CHANGE COLUMN - Amazon Athena
SynopsisExample
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 CHANGE COLUMN

Changes the name, type, order or comment of a column in an Iceberg table.

Note

ALTER TABLE REPLACE COLUMNS is not supported. Because REPLACE COLUMNS removes all columns and then adds new ones, it is not supported for Iceberg. CHANGE COLUMN is the preferred syntax for schema evolution.

Synopsis

ALTER TABLE [db_name.]table_name
  CHANGE [COLUMN] col_old_name col_new_name column_type 
  [COMMENT col_comment] [FIRST|AFTER column_name]

Example

ALTER TABLE iceberg_table CHANGE comment blog_comment string AFTER id