增量实现

###参数
source ExitCodeCheck.sh
queueName=$1;
hive_db_name_360=$2;
stat_date=$3;
end_date=$4;

#### 新理赔 新增 1
hive -v -e "use ${hive_db_name_360};
set mapred.job.queue.name=queue_gbd_ide_02;
set hive.cli.print.header=false;
set hive.map.aggr=true;
set hive.groupby.skewindata=true;


set hive.exec.parallel=true;


insert overwrite table GBD_DM_PAC_SAFE.MID_T1_T1_AUTO_CLAIM_PROPERTY_NEW
  select A.REPORT_NO, A.CASE_TIMES
    from (select A.REPORT_NO, A.CASE_TIMES
            from cx_edw_safe.claim_claimdata_clm_whole_case_base a
           where to_date(A.updated_date) < to_date('${end_date}')
             and to_date(A.updated_date) >= to_date('${stat_date}')
             and a.MIGRATE_FROM in ('N', 'n')
          union all
          select A.REPORT_NO, A.CASE_TIMES
            from cx_edw_safe.claim_claimdata_clm_investigation_task a
           where to_date(A.updated_date) < to_date('${end_date}')
             and to_date(A.updated_date) >= to_date('${stat_date}')
          union all
          select