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

Switch to Plain View
Pig >> mail # user >> Can I check if the field is integer or not

sonia gehlot 2012-06-07, 22:19
Copy link to this message
Re: Can I check if the field is integer or not
Hi Sonia,

We checked in UDFs for this into trunk, and will be a part of a future
release (0.11). Please take a look at
https://issues.apache.org/jira/browse/PIG-2443 to apply the patch to your
version, or just to use it externally.

In addition, this patch also includes IsFloat, IsLong and IsDouble.


On Thu, Jun 7, 2012 at 3:19 PM, sonia gehlot <[EMAIL PROTECTED]> wrote:

> Hi Guys,
> Is there is any way in Pig to check either the field is integer or not.
> I have a pig script with a field coming as string and I am expecting it to
> have always integer value, but due to some data nuisance field might
> contain string and in such cases when I cast it to integer it throughs an
> error (can't convert string into integer). Is there is any way where I can
> use case statement say if the field integer then cast it to integer else
> put '-1'.
> Thanks for any help,
> Sonia
sonia gehlot 2012-06-07, 22:31
Jagat Singh 2012-06-08, 02:08
Steve Bernstein 2012-06-08, 15:20
Kris Coward 2012-06-08, 15:27