[ https://issues.apache.org/jira/browse/BEAM-4161?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17066807#comment-17066807 ]
Kenneth Knowles commented on BEAM-4161: --------------------------------------- Resolved, right? > 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)