Hive差集工具

• 问题描述:A-B，差集运算

---

• Hive中left outer join 解决 A差B的问题

select test_1.id, test_1.num from test_1
 left outer join test_2 on (test_2.id = test_2.id)
  where test_2.num is null;