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

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.

Thanks,
Prashant

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
>

Great thanks Prashant!

On Thu, Jun 7, 2012 at 3:28 PM, Prashant Kommireddi <[EMAIL PROTECTED]>wrote:

> 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.
>
> Thanks,
> Prashant
>
> 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
> >
>

You can use regular expression

Field matches '[0-9]'

-----------
Sent from Mobile , short and crisp.
On 08-Jun-2012 3:49 AM, "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
>

...for a one digit integer, or '[0-9]+' an integer of one or more digits.
________________________________________
From: Jagat Singh [[EMAIL PROTECTED]]
Sent: Thursday, June 07, 2012 7:08 PM
To: [EMAIL PROTECTED]
Subject: Re: Can I check if the field is integer or not

You can use regular expression

Field matches '[0-9]'

-----------
Sent from Mobile , short and crisp.
On 08-Jun-2012 3:49 AM, "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
>

And both of these only cover positive/unsigned integers, and allowing
for negatives you'd want '-?[0-9]+'

On Fri, Jun 08, 2012 at 03:20:01PM +0000, Steve Bernstein wrote:
> ...for a one digit integer, or '[0-9]+' an integer of one or more digits.
> ________________________________________
> From: Jagat Singh [[EMAIL PROTECTED]]
> Sent: Thursday, June 07, 2012 7:08 PM
> To: [EMAIL PROTECTED]
> Subject: Re: Can I check if the field is integer or not
>
> You can use regular expression
>
> Field matches '[0-9]'
>
> -----------
> Sent from Mobile , short and crisp.
> On 08-Jun-2012 3:49 AM, "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
> >

--
Kris Coward http://unripe.melon.org/
GPG Fingerprint: 2BF3 957D 310A FEEC 4733  830E 21A4 05C7 1FEB 12B3