Pig
  1. Pig
  2. PIG-2443

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

    Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 0.11
    • Component/s: piggybank
    • Labels:
      None
    • Patch Info:
      Patch Available
    • Hadoop Flags:
      Reviewed
    • Tags:
      Piggybank, IsInt, IsNumeric

      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);

      1. PIG-2443.patch
        17 kB
        Prashant Kommireddi
      2. PIG-2443.2.patch
        26 kB
        Prashant Kommireddi
      3. isIntNumeric.patch
        5 kB
        Prashant Kommireddi
      4. isIntNumeric.patch
        6 kB
        Prashant Kommireddi

        Activity

        Bill Graham made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Daniel Dai made changes -
        Status Patch Available [ 10002 ] Resolved [ 5 ]
        Hadoop Flags Reviewed [ 10343 ]
        Fix Version/s 0.11 [ 12318878 ]
        Resolution Fixed [ 1 ]
        Prashant Kommireddi made changes -
        Attachment PIG-2443.2.patch [ 12509160 ]
        Prashant Kommireddi made changes -
        Attachment PIG-2443.patch [ 12508700 ]
        Thejas M Nair made changes -
        Status Open [ 1 ] Patch Available [ 10002 ]
        Prashant Kommireddi made changes -
        Attachment isIntNumeric.patch [ 12508220 ]
        Prashant Kommireddi made changes -
        Field Original Value New Value
        Attachment isIntNumeric.patch [ 12508219 ]
        Prashant Kommireddi created issue -

          People

          • Assignee:
            Prashant Kommireddi
            Reporter:
            Prashant Kommireddi
          • Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development