hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lefty Leverenz (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-9472) Implement 7 simple UDFs added to Hive
Date Tue, 27 Jan 2015 00:57:35 GMT

    [ https://issues.apache.org/jira/browse/HIVE-9472?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14292762#comment-14292762
] 

Lefty Leverenz commented on HIVE-9472:
--------------------------------------

HIVE-9358 created last_day and HIVE-9357 created add_months in trunk.

> Implement 7 simple UDFs added to Hive
> -------------------------------------
>
>                 Key: HIVE-9472
>                 URL: https://issues.apache.org/jira/browse/HIVE-9472
>             Project: Hive
>          Issue Type: Bug
>          Components: UDF
>    Affects Versions: 0.14.0
>            Reporter: Xiaobing Zhou
>            Assignee: Xiaobing Zhou
>
> PROBLEM: Hive doesn't not have the following built-in functions.
> 1) MONTHS_BETWEEN(d1,d2) 
> 2) LAST_DAY(d) 
> 3) FIRST_DAY(d) 
> 4) ADD_MONTHS (date, integer) 
> 5) CHR() 
> 6) REPLACE(char, search_string, replacement_string) 
> 7) TRANSLATE(expr, from_string, to_string)
> Without these, not able to do certain analysis.
> USE CASE:
> 1) MONTHS_BETWEEN(d1,d2) 
> 2) LAST_DAY(d) 
> 3) FIRST_DAY(d) 
> 4) ADD_MONTHS (date, integer)
> ADD_MONTHS returns the date date plus integer months. If date is the last day of the
month or if the resulting month has fewer days than the day component of date, then the result
is the last day of the resulting month. Otherwise, the result has the same day component as
date.
> 5) CHR()
> CHR returns the character having the binary equivalent to n (where n is between 0 and
255)as a VARCHAR2 value
> 6) REPLACE(char, search_string, replacement_string) 
> REPLACE returns char with every occurrence of search_string replaced with replacement_string.
> SELECT REPLACE('JACK and JUE','J','BL') "Changes";
> Changes 
> -------------- 
> BLACK and BLUE
> 7) TRANSLATE(expr, from_string, to_string) 
> TRANSLATE returns expr with all occurrences of each character in from_string replaced
by its corresponding character in to_string.
> SELECT TRANSLATE('2KR 229', '0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ ', 
> '9999999999XXXXXXXXXXXXXXXXXXXXXXXXXX-') (CHAR(26)) "License";
> License 
> ------- 
> 9XX-999



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

Mime
View raw message