Adding a Column

This statement is used to add one or more new columns to a table.

 ALTER TABLE [db_name.]table_name ADD COLUMNS (col_name1 col_type1 [COMMENT col_comment1], ...);
 

**Table 1** Parameters
Parameter	Description
db_name	Database name that contains letters, digits, and underscores (_). It cannot contain only digits or start with an underscore (_).
table_name	Table name
col_name	Column name
col_type	Field type
col_comment	Column description

Do not run this SQL statement concurrently. Otherwise, columns may be overwritten.

 ALTER TABLE t1 ADD COLUMNS (column2 int, column3 string);
 

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.