[IMPALA-6059] Enhance ltrim() and rtrim() functions to trim any set of characters

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: Product Backlog
• Fix Version/s: Impala 3.0, Impala 2.12.0
• Component/s: Backend
• Labels: doc
• Epic Color: ghx-label-5
• Assignee: Zoram Thanga
• Reporter: Zoram Thanga
• Created: 16/Oct/17 18:27
• Updated: 05/Sep/18 20:37
• Resolved: 12/Mar/18 19:37

Description

Enhance the existing ltrim() and rtrim() string functions to accept an argument that specifies a set of characters to be trimmed from the target string. This is in line with how these functions are implemented in PostgreSQL[1], Vertica[2], etc.

The new function signatures will look like:

ltrim(string text [, characters text])
rtrim(string text [, characters text])

[1] https://www.postgresql.org/docs/9.1/static/functions-string.html
[2] http://bit.ly/2wTE52M

Issue Links

• Blocked: IMPALA-889 Add trim() function matching ANSI SQL definition
• contains: IMPALA-6764 Codegend UnionNode::MaterializeBatch() causes memory corruption crash of Impalad
• contains: IMPALA-6936 LLVM generates toxic x86 assembly for StringFunctions::Trim()

Sub-Tasks

• Impala 2.12 Doc: Update ltrim and rtrim functions: Closed