Help & Documentation>Data Lake Compute

ALTER VIEW SET TBLPROPERTIES

Last updated: 2024-01-12 10:27:05

Note

Supported kernels: Presto, SparkSQL.
Purpose: To modify view properties.

Standard Syntax

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

Category

view_identifier: The name of the view for which properties need to be modified.
property_key: Property name.
property_val: Attribute value.

Sample

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

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