[
https://issues.apache.org/jira/browse/BEAM-9777?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17085982#comment-17085982
]
Kenneth Knowles commented on BEAM-9777:
---------------------------------------
Clarification: that query represents a correlated self-cross-join, so the
output should have all the columns of pcol plus one additional column for the
struct, and each row of pcol should be duplicated once for each value in the
pcol.promo array.
> Support UNNEST(ARRAY[STRUCT()])
> -------------------------------
>
> Key: BEAM-9777
> URL: https://issues.apache.org/jira/browse/BEAM-9777
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql-zetasql
> Reporter: Andrew Pilloud
> Priority: Major
>
> It would be nice to be able to UNNEST an array of structs. For example:
> {code:sql}
> WITH pcol AS
> (SELECT 1 AS key, ARRAY[STRUCT("abc" AS name, "rst" AS slot),STRUCT("def"
> AS name, "uvw" AS slot)] AS promo
> UNION ALL
> SELECT 2 AS key, ARRAY[STRUCT("ghi" AS name, "xyz" AS slot)] AS promo)
> SELECT * FROM pcol, UNNEST(pcol.promo);
> {code}
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
