hive-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Richard <codemon...@163.com>
Subject how to join like a "In A but not in B" operation?
Date Mon, 12 Mar 2012 03:52:11 GMT
hi,
 
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.
e.g.
 
  select A.* from A join B on (A.id = B.id)
 
thanks.
Richard
Mime
View raw message