[
https://issues.apache.org/jira/browse/CALCITE-5807?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Mihai Budiu resolved CALCITE-5807.
----------------------------------
Fix Version/s: 1.38.0
Resolution: Fixed
Fixed in
https://github.com/apache/calcite/commit/9723741c3d747e0393700c7e3dbc266668fbf4d6
Thank you for the fix @hujianhong and for the review github user ILuffZhe
> 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
> Fix For: 1.38.0
>
>
> [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)
