[IMPALA-7770] SPLIT_PART to support negative indexes

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Implemented
• Fix Version/s: Impala 3.3.0
• Component/s: Backend
• Labels: built-in-function
• Epic Color: ghx-label-4
• Assignee: Norbert Luksa
• Reporter: Tristan Stevens
• Created: 26/Oct/18 08:31
• Updated: 15/Aug/19 14:13
• Resolved: 15/Aug/19 14:13

Description

Request is for SPLIT_PART to support negative indexes i.e. support right to left searching.

See Snowflake documentation for details: https://docs.snowflake.net/manuals/sql-reference/functions/split_part.html

partNr: Requested part of the split (1-based). 0 is treated as 1. If the value is negative, the parts are counted from the right side of the string.