hive 動態分割槽插入資料表

zhuzhen@123發表於2020-12-18
Hive

hive 動態分割槽插入資料表
set hive.exec.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set hive.exec.max.dynamic.partitions.pernode=2000;
set hive.exec.max.dynamic.partitions=2000;
set hive.optimize.sort.dynamic.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
insert into table_name PARTITION(dt)
select
a,
b,
c,
d,
dt
from table_name2

相關文章