Dont know about the NVL operator in detail, but seems ternary (bincond) operator can fit the bill? http://pig.apache.org/docs/r0.10.0/basic.html#artichmetic-ops
Regards, Rama. On Wed, May 8, 2013 at 7:45 PM, Catherine Miller <cmil...@mortardata.com>wrote: > I'd like to write a java UDF that functions more or less the same as a SQL > NVL command. I've been stymied on writing a general function by the fact > that I want it to work on all data types--in particular chararrays and > numeric types. If I extend EvalFunc<Object> then even if what I return is > a Double, Pig can't use it in a subsequent numeric calculation. > > Any suggestions? Has someone already written this UDF? > > Thanks, > Cat >
