Help Center/ MapReduce Service/ Component Operation Guide (LTS)/ Using Hudi/ Hudi SQL Syntax Reference/ DDL/ ALTER COLUMN
Updated on 2024-05-29 GMT+08:00
View PDF

ALTER COLUMN

This section applies only to MRS 3.3.0 or later.

Function

This command is used to change the default values of a column.

Syntax

ALTER TABLE tableIdentifier ALTER COLUMN colName SET DEFAULT defaultValue

Parameter Description

Table 1 ADD COLUMNS parameters

Parameter

Description

tableIdentifier

Table name

colName

Column name

defaultValue

Default value of a column

Example

alter table h0_1 alter column extl set default 'new_default_value';

System Response

You can view query results on the client.

Parent topic: DDL