You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "Alejandro Fernandez (JIRA)" <ji...@apache.org> on 2016/02/16 01:14:18 UTC

[jira] [Created] (HIVE-13063) Create UDFs for CHAR and REPLACE

Alejandro Fernandez created HIVE-13063:
------------------------------------------

             Summary: Create UDFs for CHAR and REPLACE 
                 Key: HIVE-13063
                 URL: https://issues.apache.org/jira/browse/HIVE-13063
             Project: Hive
          Issue Type: Improvement
          Components: HiveServer2
    Affects Versions: 1.2.0
            Reporter: Alejandro Fernandez
            Assignee: Alejandro Fernandez
             Fix For: 2.1.0


Create UDFS for these functions.

CHAR: 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'"



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)