数据湖探索 DLI-创建表时指定表的生命周期:语法格式

时间：2023-11-03 17:00:59

数据湖探索 DLI 表生命周期管理

语法格式

DataSource语法创建DLI表

CREATE TABLE table_name(name string, id int) 
USING parquet 
TBLPROPERTIES( "dli.lifecycle.days"=1 );

Hive语法创建DLI表

CREATE TABLE table_name(name string, id int) 
stored as parquet 
TBLPROPERTIES( "dli.lifecycle.days"=1 );

DataSource语法创建OBS表

CREATE TABLE table_name(name string, id int) 
USING parquet 
OPTIONS (path "obs://dli-test/table_name")
TBLPROPERTIES( "dli.lifecycle.days"=1, "external.table.purge"='true', "dli.lifecycle.trash.dir"='obs://dli-test/Lifecycle-Trash' );

Hive语法创建OBS表

CREATE TABLE table_name(name string, id int) 
STORED AS parquet 
LOCATION 'obs://dli-test/table_name'
TBLPROPERTIES( "dli.lifecycle.days"=1, "external.table.purge"='true', "dli.lifecycle.trash.dir"='obs://dli-test/Lifecycle-Trash' );