[
https://issues.apache.org/jira/browse/BEAM-9075?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17015336#comment-17015336
]
Rui Wang edited comment on BEAM-9075 at 1/14/20 7:20 PM:
---------------------------------------------------------
Thanks Brian.
To clarify, currently we just temporally rolled back the change that caused the
break. We need to further work on it to solve the break from root.
The fix will likely be related to how will we want to support struct or nested
struct in ZetaSQL planner.
was (Author: amaliujia):
Thanks Brian.
To clarify, currently we just temporally rolled back the change that caused the
break. We need to further work on it to solve the break from root.
> Join re-ordering doesn't work for ZetaSQL
> -----------------------------------------
>
> Key: BEAM-9075
> URL: https://issues.apache.org/jira/browse/BEAM-9075
> Project: Beam
> Issue Type: Bug
> Components: dsl-sql-zetasql
> Affects Versions: 2.17.0
> Reporter: Brian Hulette
> Assignee: Brian Hulette
> Priority: Major
> Time Spent: 1h 50m
> Remaining Estimate: 0h
>
> Join re-ordering can actually break queries in the ZetaSQL planner because
> Calcite's JoinCommuteRule doesn't work when schemas have nested fields. It
> only adjusts RexInputRef nodes and not RexFieldAccess.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
