[jira] [Commented] (HIVE-3559) UDF RIGHT(string,position) to HIVE

[Arun A K (JIRA)]

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

Arun A K commented on HIVE-3559:


[~vinayavarghese], Please find the patch added.

Quoting the review request https://reviews.apache.org/r/9248/

> 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
> 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 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

[jira] [Commented] (HIVE-3559) UDF RIGHT(string,position) to HIVE

[Arun A K (JIRA)]

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

Arun A K commented on HIVE-3559:


[~meenu]
Please review the patch submitted. I have seen ample number of bugs in the 
current version of the patch.

eg:
 
String null, length 3
String "teststring", length 200
String "test", length -1
...

Do take time and fix these bugs and add new patch file. 

> 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: Meenu K Chandran
>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 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