You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2012/12/19 07:31:14 UTC
[jira] [Updated] (HIVE-3559) UDF RIGHT(string,position) to HIVE
[ https://issues.apache.org/jira/browse/HIVE-3559?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Ashutosh Chauhan updated HIVE-3559:
-----------------------------------
Fix Version/s: (was: 0.10.0)
> 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
>
> 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