You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@pig.apache.org by "Rohini Palaniswamy (JIRA)" <ji...@apache.org> on 2015/10/08 23:45:27 UTC

[jira] [Updated] (PIG-4673) Built In UDF - REPLACE_MULTI : For a given string, search and replace all occurrences of search keys with replacement values.

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

Rohini Palaniswamy updated PIG-4673:
------------------------------------
    Attachment: PIG-4673-fix-test-failure.patch

There were test failures due to moving the UDF to piggybank.  PIG-4673-fix-test-failure.patch fixes that and also renames (svn mv while committing) TestBuiltinReplaceMulti.java to TestReplaceMulti.java

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