tencent cloud

문서Data Lake Compute

ALTER TABLE SET TBLPROPERTIES

다운로드
포커스 모드
폰트 크기
마지막 업데이트 시간: 2024-08-07 17:17:31

Description

Supported engines: Presto and SparkSQL
Applicable table: Native Iceberg table and external table.
Purpose: Update/delete the data table attribute.

SET: Update Attribute

Statement

ALTER TABLE table_name
SET TBLPROPERTIES (property_name=property_value, ...)

Parameter

table_name: Name of the target table.
property_name: Name of the attribute to be updated.
property_value: Value of the attribute to be updated.

Example

ALTER TABLE orders SET TBLPROPERTIES ('notes'="Please don't drop this table.");

UNSET: Delete Attribute

Statement

ALTER TABLE table_name
UNSET TBLPROPERTIES (property_name, ...)

Parameter

table_name: Name of the target table
property_name: Name of the attribute to be deleted.

Example

ALTER TABLE dempts UNSET TBLPROPERTIES ('read.split.target-size')




도움말 및 지원

문제 해결에 도움이 되었나요?

피드백