[jira] [Commented] (FLINK-33449) Support array_contains_seq function

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

    [ https://issues.apache.org/jira/browse/FLINK-33449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17796532#comment-17796532 ] 

xuyang commented on FLINK-33449:
--------------------------------

Hi, [~leoyy] thanks for driving this. IMO, this type of function is very useful, and I'm +1 to support this function.

However, the function names in some database or big data system are different. Take examples of the systems you mentioned as following.

1. Clickhouse `hasAll(set, subset)`

2. Trino `contains_sequence(x, seq)`

3. Starrocks `array_contains_all(arr1, arr2)`

The function names are not unified. In Flink, there has been a function named `ARRAY_CONTAINS(haystack, needle)` to check if the given element exists in an array. What about using `ARRAY_CONTAINS_ALL` to implement the function in this JIRA?

For a more formal process, maybe a discussion mail thread should be started in dev maillist.

Look for your thought. cc [~martijnvisser] 

> Support array_contains_seq function
> -----------------------------------
>
>                 Key: FLINK-33449
>                 URL: https://issues.apache.org/jira/browse/FLINK-33449
>             Project: Flink
>          Issue Type: New Feature
>            Reporter: leo cheng
>            Priority: Minor
>              Labels: pull-request-available
>
> support function array_contains_seq like trino contains_sequence
> trino: https://trino.io/docs/current/functions/array.html?highlight=contains_sequence#contains_sequence



--
This message was sent by Atlassian Jira
(v8.20.10#820010)