[jira] [Comment Edited] (BEAM-9075) Join re-ordering doesn't work for ZetaSQL

["Rui Wang (Jira)" <ji...@apache.org>]

    [ 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)