Updated on 2025-02-22 GMT+08:00

SET

Enabling Schema Evolution

Set the following parameter:

hoodie.schema.evolution.enable=true

Function

The ALTER TABLE ... SET|UNSET command is used to modify table properties.

Syntax

ALTER TABLE Table name SET|UNSET tblproperties

Parameter Description

Table 1 Parameter descriptions

Parameter

Description

tableName

Table name.

tblproperties

Table properties.

Example

ALTER TABLE table SET TBLPROPERTIES ('table_property' = 'property_value')
ALTER TABLE table UNSET TBLPROPERTIES [IF EXISTS] ('comment', 'key')

System Response

You can run the DESCRIBE command to view new table properties.