set hive.exec.dynamic.partition=true;

set hive.exec.dynamic.partition.mode=nonstrict;

set hive.support.quoted.identifiers=none;

set hive.exec.dynamic.partition=true;

set hive.exec.dynamic.partition.mode=nonstrict;

set hive.exec.max.dynamic.partitions=1000000;

set hive.exec.max.dynamic.partitions.pernode=1000000;

set hive.execution.engine=spark;

INSERT INTO table dm.dm_contract_overdue_dtl_day partition (p_day_id)

SELECT

contract_id,

borrow_name,

finan_product,

active_date ,

car_type,

car_price,

car_exprice,

od_days,

loan_money,

unpaid_money,

loan_period,

od_period,

paid_period,

month_money,

should_period,

should_interest,

should_money,

car_dealer,

penalty,

fee,

car_status,

service_type,

applicationno,

p_day_id

FROM DM.DM_CALLTASK_DAY WHERE p_day_id<20210316

ITPub博客

带分区拷贝数据（自动创建分区）