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/09/07 20:32:45 UTC

[jira] [Created] (CALCITE-877) Allow ROW as argument to COLLECT

Julian Hyde created CALCITE-877:
-----------------------------------

             Summary: Allow ROW as argument to COLLECT
                 Key: CALCITE-877
                 URL: https://issues.apache.org/jira/browse/CALCITE-877
             Project: Calcite
          Issue Type: Bug
            Reporter: Julian Hyde
            Assignee: Julian Hyde


We would like to build multisets of records, for instance all of the employees in a department: {code}SELECT deptno, COLLECT(ROW(ename, salary)) AS emps
FROM emp
GROUP BY deptno{code}

Standard SQL only allows ROW inside a table constructor (i.e. a VALUES clause). A workaround is to create a user-defined type (CREATE TYPE; see http://www.oracle-developer.net/display.php?id=306) but it would be preferable to be able to create rows of anonymous type, so that the above SELECT statement just works.



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