hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vinaya Varghese (JIRA)" <j...@apache.org>
Subject [jira] [Assigned] (HIVE-3559) UDF RIGHT(string,position) to HIVE
Date Fri, 26 Feb 2016 09:10:18 GMT

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

Vinaya Varghese reassigned HIVE-3559:
-------------------------------------

    Assignee: Vinaya Varghese  (was: Meenu K Chandran)

> UDF  RIGHT(string,position) to HIVE
> -----------------------------------
>
>                 Key: HIVE-3559
>                 URL: https://issues.apache.org/jira/browse/HIVE-3559
>             Project: Hive
>          Issue Type: New Feature
>          Components: UDF
>    Affects Versions: 0.9.0
>            Reporter: Vinaya Varghese
>            Assignee: Vinaya Varghese
>            Priority: Minor
>         Attachments: HIVE-3559.1.patch.txt, udf_right.q, udf_right.q.out
>
>
> Introduction
> 	UDF (User Defined Function) to obtain the rightmost 'n' characters from a string in
 HIVE. 
> Relevance
> 	Current releases of Hive lacks a function which would returns the rightmost len characters
from the string str, or NULL if any argument is NULL. The function LEFT(string,length)  would
return the rightmost 'length' characters from the string 'string' , or NULL if any argument
is NULL which would be useful while using HiveQL. This would find its use  in all the technical
aspects where the concept of strings are used.
> Functionality :-
> Function Name: RIGHT(string,length) 
> 	 
> Returns the rightmost 'length' characters from the string  or NULL if any argument is
NULL.  
> Example: hive>SELECT LEFT('https://www.irctc.com',3);
>         	-> 'com'
> Usage :-
> Case 1: To query a table to find details based on an https request
> Table :-Transaction
> Request_id|date|period_id|url_name
> 0001|01/07/2012|110001|https://www.irctc.com
> 0002|02/07/2012|110001|https://nextstep.tcs.com
> 0003|03/07/2012|110001|https://www.hdfcbank.com
> 0005|01/07/2012|110001|http://www.lmnm.org
> 0006|08/07/2012|110001|http://nextstart.gov
> 0007|10/07/2012|110001|https://netbanking.icicibank.com
> 0012|21/07/2012|110001|http://www.people.nic
> 0026|08/07/2012|110001|http://nextprobs.gov
> 00023|25/07/2012|110001|https://netbanking.canarabank.com
> Query : select * from transaction where RIGHT(url_name,3)='com';
> Result :-
> 0001|01/07/2012|110001|https://www.irctc.com
> 0002|02/07/2012|110001|https://nextstep.tcs.com  
> 0003|03/07/2012|110001|https://www.hdfcbank.com
> 0007|10/07/2012|110001|https://netbanking.icicibank.com
> 00023|25/07/2012|110001|https://netbanking.canarabank.com



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

Mime
View raw message