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

• Type: New Feature
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: site
• Fix Version/s: 0.16.0
• Component/s: piggybank
• Hadoop Flags: Reviewed
• Release Note: Built In UDF - REPLACE_MULTI : Method which take a tuple having source string as first parameter and a map having search key and replacement values. Method will replace all occurrences of search key in source string with the replacement values.
• Assignee: Murali Rao
• Reporter: Murali Rao
• Created: 09/Sep/15 22:21
• Updated: 08/Jun/16 20:48
• Resolved: 17/Sep/15 02:44

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('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.