[PIG-2443] [Piggybank] Add UDFs to check if a String is an Integer And if a String is Numeric

• Type: New Feature
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.11
• Component/s: piggybank
• Patch Info: Patch Available
• Hadoop Flags: Reviewed
• Tags: Piggybank, IsInt, IsNumeric
• Assignee: Prashant Kommireddi
• Reporter: Prashant Kommireddi
• Created: 21/Dec/11 09:58
• Updated: 22/Feb/13 04:53
• Resolved: 03/Jan/12 04:51

Description

UDF that could be used to check if a String is numeric (or an Integer). Several tools such as Splunk, AbInitio have this UDF built-in and companies making an effort to move to Hadoop/Pig could use this.

Use Case:
In raw logs there are certain filters/conditions applied based on whether a particular field/value is numeric or not. For eg, SPLIT A INTO CATEGORY1 IF IsInt($0), CATEGORY2 IF !IsInt($0);