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)
