tencent cloud

ALTER VIEW SET TBLPROPERTIES
Download PDF
Last updated: 2024-08-07 17:23:59
ALTER VIEW SET TBLPROPERTIES
Last updated: 2024-08-07 17:23:59
Download PDF

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')



Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback