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

• Type: New Feature
• Status: Resolved
• Priority: P2
• Resolution: Fixed
• Fix Version/s: 2.25.0
• Component/s: dsl-sql-zetasql
• Assignee: Robin Qiu
• Reporter: Robin Qiu
• Created: 14/Sep/20 23:22
• Updated: 15/May/21 17:56
• Resolved: 15/May/21 17:56

Description

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)

Issue Links

• links to: GitHub Pull Request #12843