Please try this in Hive: select distinct a.id from tableA a LEFT OUTER join tableB b on a.id=b.id where b.id is null
Cheers, Tim On Wed, Nov 3, 2010 at 1:19 PM, Tim Robertson <timrobertson...@gmail.com> wrote: > In SQL you use a left join: > > # so in mysql: > select distinct a.id from tableA a left join tableB b on a.id=b.id > where b.id is null > > Not sure exactly how that ports to Hive, but it should be something > along those lines. > > HTH, > Tim > > > On Wed, Nov 3, 2010 at 1:13 PM, איל (Eyal) <eya...@gmail.com> wrote: >> Hi, >> >> I have a table A with some values and another table B with some other values >> >> How do I get all the distinct values from A that are NOT in B >> >> e.g >> >> if table A has values 1,2,3,4,1,2,3,5,6,7 and B has values 2,3,4,5,6 >> >> then the result should be 1,7 >> >> Thanks >> Eyal >> >
