Hello, How do we implement the following "if-else" SQL logic in Pig ?
Select column-1, column-2, if(column-3 >=200, 20, column-3) column_new_3 >From table-1 In the above SQL , if the value of a field (column-3) is greater than threshold (200), it uses some other value(20). Else, it uses the original value itself. Thanks, Jay
