You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Julian Hyde (JIRA)" <ji...@apache.org> on 2015/08/27 04:58:45 UTC

[jira] [Created] (CALCITE-854) Implement UNNEST ... WITH ORDINALITY

Julian Hyde created CALCITE-854:
-----------------------------------

             Summary: Implement UNNEST ... WITH ORDINALITY
                 Key: CALCITE-854
                 URL: https://issues.apache.org/jira/browse/CALCITE-854
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


The SQL standard provides UNNEST, a function that converts a multiset- or array-valued scalar expression into a relation. Calcite already implements this (for multisets).

This case would add support for WITH ORDINALITY, the generated relation has an additional ORDINALITY column that contains the position of the element in the array.

See http://farrago.sourceforge.net/design/CollectionTypes.html for examples.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)