[jira] [Updated] (FLINK-29172) Add built-in string_split function.

["Ruan Hang (Jira)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/FLINK-29172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ruan Hang updated FLINK-29172:
------------------------------
    Fix Version/s: 2.3.0
                       (was: 2.2.0)

> Add built-in string_split function.
> -----------------------------------
>
>                 Key: FLINK-29172
>                 URL: https://issues.apache.org/jira/browse/FLINK-29172
>             Project: Flink
>          Issue Type: Improvement
>          Components: Table SQL / API
>    Affects Versions: 2.1.0
>            Reporter: Yongming Zhang
>            Priority: Major
>             Fix For: 2.3.0
>
>
> Syntax:
> {code:java}
> STRING_SPLIT ( string , separator [ , enable_ordinal ] )  {code}
> h2. Arguments
> h4. _string_
> Is an [expression|https://docs.microsoft.com/en-us/sql/t-sql/language-elements/expressions-transact-sql?view=sql-server-ver16] of any character type (for example, {*}nvarchar{*}, {*}varchar{*}, {*}nchar{*}, or {*}char{*}).
> h4. _separator_
> Is a single character [expression|https://docs.microsoft.com/en-us/sql/t-sql/language-elements/expressions-transact-sql?view=sql-server-ver16] of any character type (for example, {*}nvarchar(1){*}, {*}varchar(1){*}, {*}nchar(1){*}, or {*}char(1){*}) that is used as separator for concatenated substrings.
> h4. _enable_ordinal_
> An *int* or *bit* [expression|https://docs.microsoft.com/en-us/sql/t-sql/language-elements/expressions-transact-sql?view=sql-server-ver16] that serves as a flag to enable or disable the {{ordinal}} output column. A value of 1 enables the {{ordinal}} column. If _enable_ordinal_ is omitted, {{{}NULL{}}}, or has a value of 0, the {{ordinal}} column is disabled.
> See more:
>  * sql server: https://docs.microsoft.com/en-us/sql/t-sql/functions/string-split-transact-sql?view=sql-server-ver16



--
This message was sent by Atlassian Jira
(v8.20.10#820010)