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

Create UDFs for CHR and REPLACE

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 1.2.0
    • 1.3.0, 2.1.0
    • HiveServer2
    • 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. Screen Shot 2016-02-17 at 7.21.07 PM.png
          71 kB
          Alejandro Fernandez
        2. Screen Shot 2016-02-17 at 7.20.57 PM.png
          66 kB
          Alejandro Fernandez
        3. HIVE-13063.patch
          19 kB
          Alejandro Fernandez

        Issue Links

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved: