[BEAM-11937] SqlTransform: projecting field from array of rows does not work

• Type: Bug
• Status: Resolved
• Priority: P2
• Resolution: Won't Fix
• Fix Version/s: Not applicable
• Component/s: dsl-sql
• Assignee: Unassigned
• Reporter: Brian Hulette
• Created: 08/Mar/21 20:44
• Updated: 08/Mar/21 22:42
• Resolved: 08/Mar/21 22:42

Description

For an input with type:

f_int: INT32
f_array: ARRAY<ROW<f_nestedString: STRING, f_nestedInt: INT32>>

The query SELECT 1 as `f_int`, f_array[0].f_nestedInt as `f_nestedInt_extracted` FROM PCOLLECTION does not correctly project f_nestedInt_extracted, instead always producing null.

Issue Links

• links to: GitHub Pull Request #14169