Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13063

Create UDFs for CHR and REPLACE

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.0
    • Fix Version/s: 1.3.0, 2.1.0
    • Component/s: HiveServer2
    • Labels:
      None

      Description

      Create UDFS for these functions.

      CHR: convert n where n : [0, 256) into the ascii equivalent as a varchar. If n is less than 0 or greater than 255, return the empty string. If n is 0, return null.

      REPLACE: replace all substrings of 'str' that match 'search' with 'rep'.
      Example. SELECT REPLACE('Hack and Hue', 'H', 'BL');
      Equals 'BLack and BLue'"

        Attachments

        1. HIVE-13063.patch
          19 kB
          Alejandro Fernandez
        2. Screen Shot 2016-02-17 at 7.20.57 PM.png
          66 kB
          Alejandro Fernandez
        3. Screen Shot 2016-02-17 at 7.21.07 PM.png
          71 kB
          Alejandro Fernandez

          Issue Links

            Activity

              People

              • Assignee:
                afernandez Alejandro Fernandez
                Reporter:
                afernandez Alejandro Fernandez
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: