数据湖探索 DLI-CREATE TABLE AS SELECT:示例

时间：2025-02-12 15:00:27

数据湖探索 DLI

示例

创建分区表

create table if not exists delta_table0using deltapartitioned by (dt)location 'obs://bucket_name0/db0/delta_table0'asselect 1 as id, 'a1' as name, 10 as price, 1000 as dt;

创建非分区表

create table if not exists delta_table0using deltalocation 'obs://bucket_name0/db0/delta_table0'asselect 1 as id, 'a1' as name, 10 as price;create table delta.`obs://bucket_name0/db0/delta_table0`using deltapartitioned by (part_col1, part_col2)as select id,name,year,class_name from table1 where part_col1=2024;

上一篇：数据湖探索 DLI-RESTORE:参数描述

下一篇：数据湖探索 DLI-RESTORE:参数描述