This type of in is really a semi-join. So you could rewrite this as: B1 = join A by A1, C by A1; B2 = filter B1 by SIZE(C) > 0; B = foreach B2 flatten(A);
Alan. On Jun 25, 2012, at 2:50 AM, yonghu wrote: > Dear all, > > in the sql, there is a in clause which is used to check if the value > is in a set or not? Does pig also have the same in clause? Such as: > > B = filter A by A1 in C; > > A,B,C are relation names and A1 is a column_name of A. > > Thanks! > > Yong
