pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Murali Rao (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (PIG-4673) Built In UDF - REPLACE_MULTI : For a given string, search and replace all occurrences of search keys with replacement values.
Date Wed, 09 Sep 2015 23:08:46 GMT

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

Murali Rao updated PIG-4673:
----------------------------
    Description: 
Lets say we have a string = 'A1B2C3D4'. Our objective is to replace A with 1, B with 2, C
with 3 and D with 4 to derive 11223344 string. 

Using existing REPLACE method 

REPLACE(REPLACE(REPLACE(REPLACE('ABCD','A','1'),'B','2'),'C','3'),'D','4') 

With proposed UDF : REPLACE_MULTI method

General Syntax : 

REPLACE_MULTI( sourceString,  [  search1#replacement1, ... ] )

REPLACE_MULTI('abcd',['A'#'1','B'#'2', 'C'#'3', 'D'#'4'])


Advantage : 

	1. Function calls are reduced. 
	2. Ease to code and better readable.
	
Let me know your thoughts/ inputs on having this UDF in Piggy Bank. Will take this up based
on this.


  was:
Lets say we have a string = 'A1B2C3D4'. Our objective is to replace A with 1, B with 2, C
with 3 and D with 4 to derive 11223344 string. 

Using existing REPLACE method 

REPLACE(REPLACE(REPLACE(REPLACE('ABCD','A','1'),'B','2'),'C','3'),'D','4') 

With proposed UDF : REPLACE_MULTI method

General Syntax : 

REPLACE_MULTI(String sourceString, [search1#replacement1, ...] )

REPLACE_MULTI('abcd',['A'#'1','B'#'2', 'C'#'3', 'D'#'4'])


Advantage : 

	1. Function calls are reduced. 
	2. Ease to code and better readable.
	
Let me know your thoughts/ inputs on having this UDF in Piggy Bank. Will take this up based
on this.



> Built In UDF - REPLACE_MULTI : For a given string, search and replace all occurrences
of search keys with replacement values. 
> ------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: PIG-4673
>                 URL: https://issues.apache.org/jira/browse/PIG-4673
>             Project: Pig
>          Issue Type: New Feature
>          Components: piggybank
>            Reporter: Murali Rao
>            Assignee: Murali Rao
>            Priority: Minor
>
> Lets say we have a string = 'A1B2C3D4'. Our objective is to replace A with 1, B with
2, C with 3 and D with 4 to derive 11223344 string. 
> Using existing REPLACE method 
> REPLACE(REPLACE(REPLACE(REPLACE('ABCD','A','1'),'B','2'),'C','3'),'D','4') 
> With proposed UDF : REPLACE_MULTI method
> General Syntax : 
> REPLACE_MULTI( sourceString,  [  search1#replacement1, ... ] )
> REPLACE_MULTI('abcd',['A'#'1','B'#'2', 'C'#'3', 'D'#'4'])
> Advantage : 
> 	1. Function calls are reduced. 
> 	2. Ease to code and better readable.
> 	
> Let me know your thoughts/ inputs on having this UDF in Piggy Bank. Will take this up
based on this.



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

Mime
View raw message