ALTER TABLE SET TBLPROPERTIES
Last updated: 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_nameSET 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_nameUNSET TBLPROPERTIES (property_name, ...)
Parameter
table_name: Name of the target tableproperty_name: Name of the attribute to be deleted.Example
ALTER TABLE dempts UNSET TBLPROPERTIES ('read.split.target-size')
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No
Feedback