[
https://issues.apache.org/jira/browse/CALCITE-5695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17721379#comment-17721379
]
Julian Hyde commented on CALCITE-5695:
--------------------------------------
In calcites type system an unordered array would be called a MULTISET.
> Add MAP_KEYS and MAP_VALUES for Spark dialect
> ---------------------------------------------
>
> Key: CALCITE-5695
> URL: https://issues.apache.org/jira/browse/CALCITE-5695
> 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
>
>
> {{MAP_KEYS}} - Returns an unordered array containing the keys of the map. If
> the map itself is null, the function will return null.
> {{MAP_VALUES}} - Returns an unordered array containing the values of the map.
> If the map itself is null, the function will return null.
> For more details
> [https://spark.apache.org/docs/latest/sql-ref-functions-builtin.html]
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
