[
https://issues.apache.org/jira/browse/BEAM-10895?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Robin Qiu updated BEAM-10895:
-----------------------------
Fix Version/s: 2.25.0
> Support UNNEST an (possibly nested) array field of an struct column
> -------------------------------------------------------------------
>
> Key: BEAM-10895
> URL: https://issues.apache.org/jira/browse/BEAM-10895
> Project: Beam
> Issue Type: New Feature
> Components: dsl-sql-zetasql
> Reporter: Robin Qiu
> Assignee: Robin Qiu
> Priority: P2
> Fix For: 2.25.0
>
> Time Spent: 50m
> Remaining Estimate: 0h
>
> Currently Beam ZetaSQL only support UNNEST an array column of a table:
>
> e.g. SELECT * FROM table, UNNEST(table.array_col)
>
> From the ZetaSQL spec, UNNEST should also work on (possibly nested) array
> field of an struct column:
>
> e.g. 1: SELECT * FROM table, UNNEST(table.struct_col.array_field)
> e.g. 2: SELECT * FROM table, UNNEST(table.struct_col.struct_field.array_field)
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
