No, currently there is no support for in clause in Pig. I had the same question the other day.
The alternative to use an UDF. I wonder if it makes sense to add this support in future version of Pig. Hien On 6/25/12 2:50 AM, "yonghu" <[email protected]> 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
