Dataworks

一、MaxCompute

开发参考：SQL (opens new window)

1.1 生命周期操作

生命周期操作 (opens new window)

1.1.1 设置生命周期lifecycle

alter table <table_name> set lifecycle <days>;

1.1.2 表级别设置自动删除表

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

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

alter table xy_data.ads_order_detail_mi_nft set tblproperties('lifecycle.deletemeta'='false');