ALTER TABLE [schema_name.]table_name SET PROPERTIES ('key1'='value1' [, 'key2'='value2' ...]);
ALTER SCHEMA schema_name SET PROPERTIES ('key1'='value1' [, ...]);
ALTER WORKSPACE workspace_name SET PROPERTIES ('key1'='value1' [, ...]);
示例
-- 为表设置压缩和自动刷新属性
ALTER TABLE sales_records SET PROPERTIES ('compression'='zstd', 'auto_refresh'='true');
-- 为 Schema 设置数据保留期
ALTER SCHEMA reporting SET PROPERTIES ('data_retention_days'='90');
-- 为 Workspace 设置属性
ALTER WORKSPACE analytics_ws SET PROPERTIES ('aa'='bb');
UNSET PROPERTIES
移除数据对象上已设置的属性，恢复为系统默认配置。
语法
ALTER TABLE [schema_name.]table_name UNSET PROPERTIES (key1 [, key2 ...]);
ALTER SCHEMA schema_name UNSET PROPERTIES (key1 [, ...]);
ALTER WORKSPACE workspace_name UNSET PROPERTIES (key1 [, ...]);
示例
-- 移除表的单个属性
ALTER TABLE sales_records UNSET PROPERTIES ('compression');
-- 同时移除多个属性
ALTER TABLE customer_feedback UNSET PROPERTIES ('auto_refresh', 'compression');
-- 移除 Schema 属性
ALTER SCHEMA reporting UNSET PROPERTIES ('data_retention_days');
⚠️ 移除不存在的属性时静默成功，不报错。
SHOW PROPERTIES
查看数据对象当前设置的所有属性。
语法
SHOW PROPERTIES IN TABLE [schema_name.]table_name;
SHOW PROPERTIES IN SCHEMA schema_name;
SHOW PROPERTIES IN WORKSPACE workspace_name;
示例
SHOW PROPERTIES IN TABLE sales_data;
SHOW PROPERTIES IN SCHEMA reporting;
SHOW PROPERTIES IN WORKSPACE data_science;
