Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Hudi/ Hudi SQL Syntax Reference/ Hudi DDL Syntax/ ALTER ADD COLUMNS
Updated on 2024-12-13 GMT+08:00
View PDF
Share

ALTER ADD COLUMNS

This section applies only to MRS 3.2.0-LTS to MRS 3.3.1-LTS.

Function

This command is used to add columns to an existing table.

Syntax

ALTER TABLE tableIdentifier ADD COLUMNS(colAndType (,colAndType)*)

Parameter Description

Table 1 Parameters

Parameter

Description

tableIdentifier

Table name.

colAndType

Name of a comma-separated column with data types. A column name consists of letters, digits, and underscores (_).

Examples

alter table h0_1 add columns(ext0 string);

System Response

The columns are added to the table. You can run the DESCRIBE command to display the columns.

Parent topic: Hudi DDL Syntax