[
https://issues.apache.org/jira/browse/BEAM-4161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17067082#comment-17067082
]
Rui Wang commented on BEAM-4161:
--------------------------------
Need to upgrade calcite and take another check.
> 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
> Assignee: Rui Wang
> Priority: Major
>
> 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)
