[
https://issues.apache.org/jira/browse/BEAM-11937?focusedWorklogId=562656&page=com.atlassian.jira.plugin.system.issuetabpanels:worklog-tabpanel#worklog-562656
]
ASF GitHub Bot logged work on BEAM-11937:
-----------------------------------------
Author: ASF GitHub Bot
Created on: 08/Mar/21 22:40
Start Date: 08/Mar/21 22:40
Worklog Time Spent: 10m
Work Description: TheNeuralBit commented on pull request #14169:
URL: https://github.com/apache/beam/pull/14169#issuecomment-793137004
Shoot, you're right, indexing with 1 does work. Sorry about that.
I found it surprising that accessing a nested column from a `null` row also
returns `null`, but just confirmed we do the same thing for a standard row (not
in an array).
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
[email protected]
Issue Time Tracking
-------------------
Worklog Id: (was: 562656)
Time Spent: 40m (was: 0.5h)
> 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
> Time Spent: 40m
> 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)
