You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@beam.apache.org by "Robin Qiu (Jira)" <ji...@apache.org> on 2020/09/14 23:23:00 UTC

[jira] [Created] (BEAM-10895) Support UNNEST an (possibly nested) array field of an struct column

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)