sonia gehlot 2012-06-07, 22:19
Prashant Kommireddi 2012-06-07, 22:28
sonia gehlot 2012-06-07, 22:31
-Re: Can I check if the field is integer or not
Jagat Singh 2012-06-08, 02:08
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,
Steve Bernstein 2012-06-08, 15:20
Kris Coward 2012-06-08, 15:27