[
https://issues.apache.org/jira/browse/BEAM-4161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17179773#comment-17179773
]
Beam JIRA Bot commented on BEAM-4161:
-------------------------------------
This issue is P2 but has been unassigned without any comment for 60 days so it
has been labeled "stale-P2". If this issue is still affecting you, we care!
Please comment and remove the label. Otherwise, in 14 days the issue will be
moved to P3.
Please see https://beam.apache.org/contribute/jira-priorities/ for a detailed
explanation of what these priorities mean.
> Nested Rows flattening doesn't work
> -----------------------------------
>
> Key: BEAM-4161
> URL: https://issues.apache.org/jira/browse/BEAM-4161
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql
> Reporter: Anton Kedin
> Priority: P2
> Labels: stale-P2
>
> Calcite flattens nested rows. It updates the field indices of the flattened
> row so the fields are referenced correctly in the Rel Nodes. But the fields
> after the flattened row don't have the indices updated, they have the
> previous ordinals before the flattening. There is no way to look up the
> correct index at the point when it reaches Beam SQL Rel Nodes. It will be
> fixed in Calcite 1.17.
> We need to update the Calcite as soon as it is released and add few
> integration tests around nested Rows:
> - basic nesting with fields before and after the row field;
> - multi-level row nesting;
> - multiple row fields;
>
> Calcite JIRA: CALCITE-2220
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
