[
https://issues.apache.org/jira/browse/BEAM-11937?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Brian Hulette updated BEAM-11937:
---------------------------------
Fix Version/s: Not applicable
Resolution: Won't Fix
Status: Resolved (was: Triage Needed)
See https://github.com/apache/beam/pull/14169#pullrequestreview-606750676
> SQL arrays are 1-indexed, did you mean to access the first element with
> f_array[1].f_nestedInt, which does work? The Index out of bounds exception is
> an optional extension to the SQL standard, so returning null isn't strictly
> incorrect.
> SqlTransform: projecting field from array of rows does not work
> ---------------------------------------------------------------
>
> Key: BEAM-11937
> URL: https://issues.apache.org/jira/browse/BEAM-11937
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql
> Reporter: Brian Hulette
> Priority: P2
> Fix For: Not applicable
>
> Time Spent: 1h
> Remaining Estimate: 0h
>
> For an input with type:
> {code}
> f_int: INT32
> f_array: ARRAY<ROW<f_nestedString: STRING, f_nestedInt: INT32>>
> {code}
> 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.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
