目录

1.创建一个cow类型的表

2.创建一个cow类型，主键为ID的表

3.创建mor类型主键更新的表

4. 创建分区表

5.CTAS(Create table as select) 创建表

5.1 CTAS创建非分区表

5.2 CTAS创建分区、主键表

1.创建一个cow类型的表

-- create a non-primary key table
create table if not exists hudi_table2(id int,name string,price double
) using hudi
options (type = 'cow'
);

2.创建一个cow类型，主键为ID的表

-- create a managed cow table
create table if not exists hudi_table0 (id int,name string,price double
) using hudi
options (type = 'cow',primaryKey = 'id'
);

3.创建mor类型主键更新的表

create table if not exists hudi_table1 (id int,name string,price double,ts bigint
) using hudi
options (type = 'mor',primaryKey = 'id,name',preCombineField = 'ts'
);

4. 创建分区表

create table if not exists hudi_table_p0 (
id bigint,
name string,
dt string,
hh string  
) using hudi
options (type = 'cow',primaryKey = 'id',preCombineField = 'ts'
)
partitioned by (dt, hh);

5.CTAS(Create table as select) 创建表

5.1 CTAS创建非分区表

create table h3 using hudi
as
select 1 as id, 'a1' as name, 10 as price;

5.2 CTAS创建分区、主键表

create table h2 using hudi
options (type = 'cow', primaryKey = 'id')
partitioned by (dt)
as
select 1 as id, 'a1' as name, 10 as price, 1000 as dt;