Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Pig, mail # user - NVL


Copy link to this message
-
Re: NVL
Ramakrishna Nalam 2013-05-08, 14:55
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 <[EMAIL PROTECTED]>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
>