set hive.exec.dynamici.partition=true;
set hive.exec.dynamic.partition.mode=nonstrict;
set mapreduce.map.java.opts="-Xmx9725955249";
insert overwrite 目标表 partition(ds)
select
ZQJC
,ZQDM
,GZRQ
,LTCS
,DCQ_N
,RJGJQJ
,RJYJLX
,GZJJ
,GJSYL
,GJXZJQ
,GJTX
,GJJDJZ
,GJLCJQ
,GZLCTX
,JQPJJSQJ
,JQPJJSJJ
,JQPJJJSYL
,PJJSJXZJQ
,JQPJJSJTX
,PJJSJJDJZ
,PJJSJLCJQ
,PJJSJLCTX
,KXD
,GJLLJQ
,GJLLTX
,PJJSJLLJQ
,PJJSJLLTX
,RZGJQJ
,RZYJLX
,SYBJ
,DCSYL
,LTCSZQDM
,GSXQHPMLL
,ISINM
,ds --分区字段
from 来源表 where ds >= 0
;