Just saw a response to this recently, the "right way" is to use co-group to join A and B and then to check IsEmpty(A) instead of doing an outer join and checking "is null"
On Mon, Mar 29, 2010 at 7:06 PM, Kent Shi <k...@ning.com> wrote: > Hi, > > I am trying to get the elements of B not in A. My code is like this > > C = JOIN A BY id RIGHT OUTER, B BY id; > D = FILTER C BY A::id is null; > > id is an INT, and this doesn't work. I also tried A::id != B::id, > (chararray)A::id == '', both also didn't work. Can someone tell me how I > should do it. > > Any help is appreciated. > > Thanks > Kent