You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@pig.apache.org by "Villalon, Oscar" <ov...@comscore.com> on 2020/05/15 14:34:16 UTC

Issue with IN operator

Hi,

I'd like to use the IN operator inside a conditional, when using GENERATE, like so:

t2 = FOREACH t1 GENERATE
    t1::f1 AS f1,
    t1::f2 AS f2,
    (((t1::f3 IN (20,40,80))) ? 'NULL' : t1::f4) AS f4,
    t1::f3 AS f3;


However, this does not work. As of now, I'm replacing that IN with a series of OR's. Is this doable currently? Is there a way to request this feature if it's not there yet?

Thanks in advance