Hive Semi Join

  • hive

posted on 09 Mar 2018 under category 人生经验

SELECT a.key, a.value
FROM a
WHERE a.key in
 (SELECT b.key
  FROM B);

等价于：

SELECT a.key, a.val
FROM a LEFT SEMI JOIN b ON (a.key = b.key)