[
https://issues.apache.org/jira/browse/CALCITE-5704?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17724749#comment-17724749
]
jackylau commented on CALCITE-5704:
-----------------------------------
hi [~julianhyde] [~libenchao] [~jiajunbernoulli]
we can talk here about the implementation.
the ArrayElementOperandTypeChecker in ARRAY_EXCEPT, ARRAY_INTERSECT and
ARRAY_UNION which refers to MultisetOperandTypeChecker
[https://github.com/apache/calcite/pull/3202#issuecomment-1556404405]
the array_contains ArrayElementOperandTypeChecker which also refers to
MultisetOperandTypeChecker
[https://github.com/apache/calcite/pull/3207/files]
they are some codes are same
when [~jiajunbernoulli] review the prs, he think it should to discuss whether
it is better ,do you have any suggestions, thanks so much.
> Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect
> -------------------------------------------------------------------
>
> Key: CALCITE-5704
> URL: https://issues.apache.org/jira/browse/CALCITE-5704
> Project: Calcite
> Issue Type: Improvement
> Components: core
> Affects Versions: 1.35.0
> Reporter: jackylau
> Priority: Major
> Labels: pull-request-available
> Fix For: 1.35.0
>
>
> array_union(array1, array2) - Returns an array of the elements in the union
> of array1 and array2, without duplicates.
> array_intersect(array1, array2) - Returns an array of the elements in the
> intersection of array1 and array2, without duplicates.
> array_except(array1, array2) - Returns an array of the elements in array1 but
> not in array2, without duplicates.
> For more details
> [https://spark.apache.org/docs/latest/api/sql/index.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
