[
https://issues.apache.org/jira/browse/FLINK-29172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jing Ge updated FLINK-29172:
----------------------------
Fix Version/s: 1.19.0
(was: 1.18.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: 1.16.0
> Reporter: Yongming Zhang
> Priority: Major
> Fix For: 1.19.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)
