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

["Brian Hulette (Jira)" <ji...@apache.org>]

     [ 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)