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
