pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rohini Palaniswamy (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (PIG-4673) Built In UDF - REPLACE_MULTI : For a given string, search and replace all occurrences of search keys with replacement values.
Date Mon, 30 Nov 2015 18:11:10 GMT

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

Rohini Palaniswamy commented on PIG-4673:
-----------------------------------------

Created PIG-4750 to fix this UDF to compile Pattern once and reuse.

> 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
>    Affects Versions: site
>            Reporter: Murali Rao
>            Assignee: Murali Rao
>            Priority: Minor
>              Labels: None
>             Fix For: 0.16.0
>
>         Attachments: PIG-4673-1.patch, PIG-4673-fix-test-failure.patch, replace_multi_udf.patch
>
>
> 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('A1B2C3D4','A','1'),'B','2'),'C','3'),'D','4') 
> With proposed UDF : REPLACE_MULTI method
> General Syntax : 
> REPLACE_MULTI ( sourceString,  [  search1#replacement1, ... ] )
> REPLACE_MULTI ( 'A1B2C3D4',  [ '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