CODEWITHSUNDEEP
apache-pig
rahul
rahul

Reputation: 1473

Pig Conditional Operators

Consider the below relation 

test = LOAD 'input' USING PigStorage(',') as (a:chararray, b:chararray);

Is there a way to achieve the following

if (b == 1) {
    a = 'abc';
else if (b == 2) {
    a = 'xyz';
else 
    // retain whatever is there in the column 'a'

Upvotes: 10

Views: 14000

Answers (1)

Frederic
Frederic

Reputation: 3284

You can do a FOREACH and use the ternary operator as follows.

test2 = FOREACH test GENERATE (b=='1' ? 'abc' : (b=='2' ? 'xyz' : a)) AS a, b;

Upvotes: 12

Related Questions