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

3.5 KiB

Raw Permalink Blame History

Modifying Table Properties

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** SET|UNSET parameters
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')

Response

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

Parent topic: SparkSQL Schema Evolution and Syntax Description

3.5 KiB Raw Permalink Blame History