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

Posted to issues@beam.apache.org by "Brian Hulette (Jira)" <ji...@apache.org> on 2021/03/08 20:45:00 UTC

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

Brian Hulette created BEAM-11937:
------------------------------------

             Summary: 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


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)