# Dataworks

# 一、MaxCompute

开发参考:SQL (opens new window)

# 1.1 生命周期操作

生命周期操作 (opens new window)

# 1.1.1 设置生命周期lifecycle

alter table <table_name> set lifecycle <days>;
1

# 1.1.2 表级别设置自动删除表

create table mf_delete_meta2(id int, name string)
     partitioned by (ds string)
     tblproperties ('lifecycle.deletemeta'='true')
     lifecycle  1;
1
2
3
4

# 1.1.3 表级别设置关闭自动删除表

alter table xy_data.ads_order_detail_mi_nft set tblproperties('lifecycle.deletemeta'='false');
1
更新时间: 4/10/2023, 2:56:54 PM