hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Vinaya Varghese (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-3559) UDF RIGHT(string,position) to HIVE
Date Tue, 09 Oct 2012 12:02:03 GMT
Vinaya Varghese created HIVE-3559:
-------------------------------------

             Summary: 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
            Priority: Minor
             Fix For: 0.10.0




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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message