Yang, Tong 48706b7552 MRS COMP-LTS 320-lts.1 version

Reviewed-by: Kacur, Michal <michal.kacur@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2024-04-12 12:51:10 +00:00

4.2 KiB

Raw Permalink Blame History

ALTER ADD COLUMNS

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

4.2 KiB Raw Permalink Blame History