hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard <>
Subject Re:Re: how to join like a "In A but not in B" operation?
Date Mon, 12 Mar 2012 07:18:16 GMT
this approach works, I did not realize "var=NULL" is different from "var is NULL" before.

At 2012-03-12 12:03:00,"Evan Pollan" <> wrote:

I used a left outer join with a constraint on a joined row column value being null -- logically
equivalent to a "not in" clause.  Looks funny, but it works. 

On Mar 11, 2012, at 10:52 PM, "Richard" <> wrote:

how can I join two tables A and B so that the result is "In A but not in B"?
let's take an example, say, the column to identify record is id.
  select A.* from A join B on ( =

View raw message