[ https://issues.apache.org/jira/browse/FLINK-29172?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
lincoln lee updated FLINK-29172: -------------------------------- Fix Version/s: (was: 1.19.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.20.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)