[jira] [Commented] (CALCITE-5704) Add ARRAY_EXCEPT, ARRAY_INTERSECT and ARRAY_UNION for Spark dialect

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

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

Julian Hyde commented on CALCITE-5704:
--------------------------------------

These should be functions in {{SqlLibraryOperators}}, but should desugar to operators such as {{ARRAY_UNION}} in {{SqlStdOperatorTable}}. Such operators should be in {{SqlStdOperatorTable}} because {{ARRAY UNION}} etc. are defined in the SQL standard. They are not currently implemented, but very similar operators {{SqlStdOperatorTable.MULTISET_UNION}} were added already (in CALCITE-2355).

> 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
>             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)