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

Switch to Threaded View
Pig >> mail # user >> UDF to check if String is Numeric or Integer


Copy link to this message
-
Re: UDF to check if String is Numeric or Integer
Prashant,
I can't find such an udf in piggybank. Yes, I think this is going to be
useful for many users.
I would be great if you can contribute such udfs to piggybank.
Thanks,
Thejas
On 12/20/11 11:39 AM, Prashant Kommireddi wrote:
> Is there a UDF that could be used to check if a string is numeric (or an
> Integer). This would be nice to have (if we don't already) as part of
> Piggybank.
> A lot of other tools such as Splunk, AbInitio have this UDF built-in and I
> know companies are making an effort to move to Hadoop/Pig which could use
> this.
>
> Use Case:
> In raw logs there are certain filters/conditions applied based on whether a
> particular field/value is numeric or not. For eg, SPLIT A INTO CATEGORY1 IF
> IsInt($0), CATEGORY2 IF !IsInt($0);
>
> Thoughts?
>
> -Prashant
>