[IMPALA-4729] REPLACE() function

• Type: New Feature
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 2.8.0
• Fix Version/s: Impala 2.9.0
• Component/s: Frontend
• Labels: built-in-function newbie
• Assignee: Zach Amsden
• Reporter: Greg Rahn
• Created: 05/Jan/17 05:02
• Updated: 14/Mar/17 18:36
• Resolved: 15/Feb/17 22:46

Description

REGEX_REPLACE() is expensive since it's depends on the Google RE2 library and sometimes just a simple replace is needed.

Reference:

• https://my.vertica.com/docs/8.0.x/HTML/Content/Authoring/SQLReferenceManual/Functions/String/REPLACE.htm
• http://docs.aws.amazon.com/redshift/latest/dg/r_REPLACE.html

Sub-Tasks

• [DOCS] Document REPLACE() function: Resolved