What if you've 10 fields?
On Wed, Sep 4, 2013 at 4:30 AM, Ruslan Al-Fakikh <[email protected]>wrote: > Hi, > > I think you could mimic it with an expression like this: > b = foreach a generate ((field1 is null) ? ((field2 is null) ? null : > field2) : field1); > > Hope that helps, > Ruslan > > > On Wed, Sep 4, 2013 at 9:50 AM, Something Something < > [email protected]> wrote: > > > Is there a UDF in Piggybank (or somewhere) that will mimic functionality > of > > the COALESCE function in MySQL: > > > > > > > http://www.w3resource.com/mysql/comparision-functions-and-operators/coalesce-function.php > > > > I know it will be very (very) easy to write this, but just don't want to > > create one if one already exists. I looked but couldn't find one. > > > > Please let me know. Thanks. > > >
