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 >
