Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Syntax for Partitioning a Table> Modifying the SerDe Attribute of a Table Partition (Only OBS Tables Supported)
View PDF

Modifying the SerDe Attribute of a Table Partition (Only OBS Tables Supported)

Function

This statement is used to modify the SerDe properties of tables or partitions.

Syntax

ALTER TABLE table_name
 [PARTITION partition_specs]
 SET SERDE serde
 [WITH SERDEPROPERTIES (property_name=property_value,...)];
ALTER TABLE table_name
 [PARTITION partition_specs]
 SET SERDEPROPERTIES (property_name=property_value,...);

Keyword

None

Precautions

  • If the SerDe property already exists, a new property will replace the original one.
  • The SerDe property configuration is applicable to the OBS table only.

Example

alter table test
 set serdeproperties (creator = "test");