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 >