Andrew Pilloud created BEAM-11872:
-------------------------------------

             Summary: Support COLLECT operator
                 Key: BEAM-11872
                 URL: https://issues.apache.org/jira/browse/BEAM-11872
             Project: Beam
          Issue Type: New Feature
          Components: dsl-sql
            Reporter: Andrew Pilloud


User would like the ARRAY(SELECT ...) operator, which becomes COLLECT.

Simple example:
{code:java}
SELECT ARRAY(SELECT f_int FROM PCOLLECTION)
{code}
We also want to make sure the original (more complex) example works:
{code:java}
SELECT
  otherScalarField,
  ARRAY(SELECT row_field1 FROM UNNEST(array_of_nested_rows)
FROM
  table
{code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to