hive 两张表全量数据对比
select
*
from (
select max(source) source,c1,c2 ,c3,count(*)
from (
select 1 source, a.* from dev.astron_wangluochayi_1 a
union all
select 2 source, b.* from dev.astron_wangluochayi_1 b
) merged_data
group by source,c1,c2 ,c3
having count(*) = 1
) minus_data
where source = 1