[
https://issues.apache.org/jira/browse/FLINK-33449?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17796606#comment-17796606
]
leo cheng commented on FLINK-33449:
-----------------------------------
Hi [~xuyangzhong] Thank you for your reply
ARRAY_CONTAINS_SEQ function in StarRocks ans trino to checks whether `arr2` is
a subset of `arr1` and in the same exact order. if and only if {{{}array1 =
prefix + array2 + suffix{}}}.
ARRAY_CONTAINS_ALL function in StarRocks and clickhouse to checks whether
`arr2` is a subset of `arr1` , but not need to in the same exact order.
Also, if we need to support ARRAY_CONTAINS_ALL , i can try to implement it in
flink.
Thank you very much.
> 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)
