[jira] [Commented] (IMPALA-7770) SPLIT_PART to support negative indexes
[ https://issues.apache.org/jira/browse/IMPALA-7770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16908105#comment-16908105 ] ASF subversion and git services commented on IMPALA-7770: - Commit 1f904719e4c7e398a7a8e152d82c8da1590b6d25 in impala's branch refs/heads/master from norbertluksa [ https://gitbox.apache.org/repos/asf?p=impala.git;h=1f90471 ] IMPALA-7770: SPLIT_PART to support negative indexes Third parameter of SPLIT_PART (nth field) accepts now negative values, and searches the string backwards. Testing: * Added unit tests to expr-test.cc Change-Id: I2db762989a90bd95661a59eb9c11a29eb2edfafb Reviewed-on: http://gerrit.cloudera.org:8080/13880 Reviewed-by: Impala Public Jenkins Tested-by: Impala Public Jenkins > SPLIT_PART to support negative indexes > -- > > Key: IMPALA-7770 > URL: https://issues.apache.org/jira/browse/IMPALA-7770 > Project: IMPALA > Issue Type: Improvement > Components: Backend >Reporter: Tristan Stevens >Assignee: Norbert Luksa >Priority: Major > Labels: built-in-function > > 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|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. -- This message was sent by Atlassian JIRA (v7.6.14#76016) - To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org
[jira] [Commented] (IMPALA-7770) SPLIT_PART to support negative indexes
[ https://issues.apache.org/jira/browse/IMPALA-7770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16896930#comment-16896930 ] Norbert Luksa commented on IMPALA-7770: --- Yes, it's only a small change. > SPLIT_PART to support negative indexes > -- > > Key: IMPALA-7770 > URL: https://issues.apache.org/jira/browse/IMPALA-7770 > Project: IMPALA > Issue Type: Improvement > Components: Backend >Reporter: Tristan Stevens >Assignee: Norbert Luksa >Priority: Major > Labels: built-in-function > > 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|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. -- This message was sent by Atlassian JIRA (v7.6.14#76016) - To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org
[jira] [Commented] (IMPALA-7770) SPLIT_PART to support negative indexes
[ https://issues.apache.org/jira/browse/IMPALA-7770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16896456#comment-16896456 ] Alex Rodoni commented on IMPALA-7770: - [~norbertluksa] Are you targeting the 3.3 release for this feature? > SPLIT_PART to support negative indexes > -- > > Key: IMPALA-7770 > URL: https://issues.apache.org/jira/browse/IMPALA-7770 > Project: IMPALA > Issue Type: Improvement > Components: Backend >Reporter: Tristan Stevens >Assignee: Norbert Luksa >Priority: Major > Labels: built-in-function > > 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|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. -- This message was sent by Atlassian JIRA (v7.6.14#76016) - To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org
[jira] [Commented] (IMPALA-7770) SPLIT_PART to support negative indexes
[ https://issues.apache.org/jira/browse/IMPALA-7770?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16896104#comment-16896104 ] Norbert Luksa commented on IMPALA-7770: --- Feel free to review: https://gerrit.cloudera.org/#/c/13880/ > SPLIT_PART to support negative indexes > -- > > Key: IMPALA-7770 > URL: https://issues.apache.org/jira/browse/IMPALA-7770 > Project: IMPALA > Issue Type: Improvement > Components: Backend >Reporter: Tristan Stevens >Assignee: Norbert Luksa >Priority: Major > Labels: built-in-function > > 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|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. -- This message was sent by Atlassian JIRA (v7.6.14#76016) - To unsubscribe, e-mail: issues-all-unsubscr...@impala.apache.org For additional commands, e-mail: issues-all-h...@impala.apache.org