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 ADD COLUMNS

Adds one or more columns to an existing Iceberg table.

Synopsis

ALTER TABLE [db_name.]table_name ADD COLUMNS (col_name data_type [,...])

Examples

The following example adds a comment column of type string to an Iceberg table.

ALTER TABLE iceberg_table ADD COLUMNS (comment string)

The following example adds a point column of type struct to an Iceberg table.

ALTER TABLE iceberg_table 
ADD COLUMNS (point struct<x: double, y: double>)

The following example adds a points column that is an array of structs to an Iceberg table.

ALTER TABLE iceberg_table 
ADD COLUMNS (points array<struct<x: double, y: double>>)