[
https://issues.apache.org/jira/browse/CALCITE-5807?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17748906#comment-17748906
]
ZheHu commented on CALCITE-5807:
--------------------------------
I'm sorry that I didn't noticed that this ticket is created by
[~MasseGuillaume] when I reviewed it.
Are you okay with it [~MasseGuillaume] or do you have any advice on this PR?
> Add SUBSTRING_INDEX function (enabled in Spark library)
> -------------------------------------------------------
>
> Key: CALCITE-5807
> URL: https://issues.apache.org/jira/browse/CALCITE-5807
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Reporter: Guillaume Massé
> Assignee: hujianhong
> Priority: Minor
> Labels: pull-request-available
>
> [https://spark.apache.org/docs/2.3.0/api/sql/#substring_index]
>
>
> {code:java}
> substring_index(str, delim, count) - Returns the substring from str before
> count occurrences of the delimiter delim. If count is positive, everything to
> the left of the final delimiter (counting from the left) is returned. If
> count is negative, everything to the right of the final delimiter (counting
> from the right) is returned. The function substring_index performs a
> case-sensitive match when searching for delim.
> Examples:
>
> > SELECT substring_index('www.apache.org', '.', 2); www.apache
> {code}
> {{}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
