[
https://issues.apache.org/jira/browse/BEAM-4161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17139598#comment-17139598
]
Beam JIRA Bot commented on BEAM-4161:
-------------------------------------
This issue was marked "stale-assigned" and has not received a public comment in
7 days. It is now automatically unassigned. If you are still working on it, you
can assign it to yourself again. Please also give an update about the status of
the work.
> 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
>
> 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)
