Hive中实现数据增量累加主键覆盖的sql

insert overwrite table full_data_table select

ddd.data_col

from

( select aa.data_col from full_data_table aa

left join

( select b.pk_col as pk_id from full_data_table a

  left join inc_data_table b on a.pk_col = b.pk_col
  
  where b.pk_col is not null and b.date_col = current_date() ) bb
  
on aa.pk_col = bb.pk_id

where bb.pk_id is null

 union all 

select cc.data_col from inc_data_table cc

where cc.date_col= current_date() ) ddd ;