tencent cloud

Data Lake Compute

DocumentationData Lake ComputeSQL StatementSuperSQL StatementUnified StatementDDL StatementALTER VIEWALTER VIEW SET TBLPROPERTIES

ALTER VIEW SET TBLPROPERTIES

Download
Focus Mode
Font Size
Last updated: 2024-08-07 17:23:59

Description

Supported engines: Presto and SparkSQL
Purpose: Change view attributes.

Standard Statement

ALTER VIEW view_identifier SET TBLPROPERTIES ( property_key = property_val [ , ... ] )

Parameter

view_identifier: Name of the view whose attributes are to be changed.
property_key: Attribute name
property_val: Attribute value

Example

alter view view1 set tblproperties('comment' = 'view1')

alter view view1 set tblproperties('property1' = 'value1', 'property2' = 'value2')



Previous Topic: ALTER VIEW RENAME TONext Topic: DROP VIEW

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback