Details

    • Type: New Feature New Feature
    • Status: Open
    • Priority: Major Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: UDF
    • Labels:
      None

      Description

      add UDFsubstring_index

      look at

      http://dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html

      for details

      1. HIVE-686.patch
        10 kB
        Larry Ogrodnek
      2. HIVE-686.patch
        11 kB
        Larry Ogrodnek

        Issue Links

          Activity

          Namit Jain created issue -
          Namit Jain made changes -
          Field Original Value New Value
          Link This issue is a clone of HIVE-685 [ HIVE-685 ]
          Namit Jain made changes -
          Summary CLONE -add UDFquote add UDF substring_index
          Description add UDFquote

          look at

          http://dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html

          for details
          add UDFsubstring_index

          look at

          http://dev.mysql.com/doc/refman/5.0/en/func-op-summary-ref.html

          for details
          Namit Jain made changes -
          Link This issue is cloned as HIVE-687 [ HIVE-687 ]
          Hide
          Larry Ogrodnek added a comment -

          I've attached code for a hive UDF that implements the substring_index function described, as well as some unit tests.

          Please review. Thanks.

          Show
          Larry Ogrodnek added a comment - I've attached code for a hive UDF that implements the substring_index function described, as well as some unit tests. Please review. Thanks.
          Larry Ogrodnek made changes -
          Attachment HIVE-686.patch [ 12429316 ]
          Hide
          Namit Jain added a comment -

          Please run all the tests - you should get a diff in show_functions.q

          Show
          Namit Jain added a comment - Please run all the tests - you should get a diff in show_functions.q
          Zheng Shao made changes -
          Assignee Larry Ogrodnek [ ogrodnek ]
          Larry Ogrodnek made changes -
          Attachment HIVE-686.patch [ 12429722 ]
          Hide
          Larry Ogrodnek added a comment -

          attached a new patch. thanks.

          Show
          Larry Ogrodnek added a comment - attached a new patch. thanks.
          Hide
          Namit Jain added a comment -

          Can you regenerate the patch - you need to include the new file in FunctionRegistry -
          udf.* is not included anymore.

          Show
          Namit Jain added a comment - Can you regenerate the patch - you need to include the new file in FunctionRegistry - udf.* is not included anymore.
          Carl Steinbach made changes -
          Component/s UDF [ 12313585 ]
          Component/s Query Processor [ 12312586 ]
          Hide
          CHEN GEN added a comment -

          BUG: this funtion is not support
          substring_index("www.test.com","test",-1)="com"
          FIX Suggestion:
          last line:
          r.set(input.substring(k + delim.length()));

          Show
          CHEN GEN added a comment - BUG: this funtion is not support substring_index("www.test.com","test",-1)="com" FIX Suggestion: last line: r.set(input.substring(k + delim.length()));

            People

            • Assignee:
              Larry Ogrodnek
              Reporter:
              Namit Jain
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:

                Development