hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Leo Alekseyev <dnqu...@gmail.com>
Subject How to implement JOIN ON (a.key <> b.key) or ...NOT IN... semantics
Date Thu, 16 Dec 2010 02:09:59 GMT
I need to get rows from table A where the key is not present in table
B.  Something like

SELECT a.val1, a.val2, a.key, b.val FROM a LEFT OUTER JOIN b ON
(a.key=b.key) WHERE b.val IS NULL

seems to achieve the desired result, but is there a better way?..

Mime
View raw message