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

时间：2025-02-12 14:55:44

数据湖探索 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' );