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

["Yongming Zhang (Jira)" <ji...@apache.org>]

Yongming Zhang created FLINK-29172:
--------------------------------------

             Summary: 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: 1.16.0
            Reporter: Yongming Zhang
             Fix For: 1.17.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)