You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Hanyu Zheng (Jira)" <ji...@apache.org> on 2023/07/27 20:19:00 UTC
[jira] [Commented] (FLINK-32706) Add SPLIT(STRING) support in SQL & Table API
[ https://issues.apache.org/jira/browse/FLINK-32706?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17748318#comment-17748318 ]
Hanyu Zheng commented on FLINK-32706:
-------------------------------------
[~martijnvisser] can you please assign this ticket to [~hanyuzheng] ?
> Add SPLIT(STRING) support in SQL & Table API
> --------------------------------------------
>
> Key: FLINK-32706
> URL: https://issues.apache.org/jira/browse/FLINK-32706
> Project: Flink
> Issue Type: Improvement
> Reporter: Hanyu Zheng
> Priority: Major
>
> SPLIT Function
> Description
> Splits a string into an array of substrings, based on a delimiter.
> Syntax
> The syntax for the SPLIT function is:
> {code:java}
> SPLIT(col1, delimiter){code}
> Splits a string into an array of substrings based on a delimiter. If the delimiter is not found, then the original string is returned as the only element in the array. If the delimiter is empty, then all characters in the string are split. If either, string or delimiter, are NULL, then a NULL value is returned.
> If the delimiter is found at the beginning or end of the string, or there are contiguous delimiters, then an empty space is added to the array.
> Example
> Let's look at some function examples and explore how to use the SPLIT function.
> For example:
>
> {code:java}
> SELECT SPLIT('abcdefg', 'c');
> Result: ['ab', 'defg']
> {code}
> see also:
> ksqldb: https://docs.ksqldb.io/en/0.8.1-ksqldb/developer-guide/ksqldb-reference/scalar-functions/#split
--
This message was sent by Atlassian Jira
(v8.20.10#820010)