hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-13063) Create UDFs for CHR and REPLACE
Date Wed, 09 Mar 2016 01:17:40 GMT

     [ https://issues.apache.org/jira/browse/HIVE-13063?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Lefty Leverenz updated HIVE-13063:
----------------------------------
    Labels: TODOC2.1  (was: )

> Create UDFs for CHR 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
>              Labels: TODOC2.1
>             Fix For: 2.1.0
>
>         Attachments: HIVE-13063.patch, Screen Shot 2016-02-17 at 7.20.57 PM.png, Screen
Shot 2016-02-17 at 7.21.07 PM.png
>
>
> 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'"



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

Mime
View raw message