Robin Qiu created BEAM-10895:
--------------------------------
Summary: 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
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)
