[
https://issues.apache.org/jira/browse/BEAM-11872?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17299150#comment-17299150
]
Andrew Pilloud commented on BEAM-11872:
---------------------------------------
Might also consider this query:
SELECT COLLECT(SELECT * FROM UNNEST(ARRAY [1, 2, 3]))
> 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
> Priority: P2
>
> 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)
