Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-9075

Join re-ordering doesn't work for ZetaSQL

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: P3
    • Resolution: Unresolved
    • Affects Version/s: 2.17.0
    • Fix Version/s: None
    • Component/s: dsl-sql-zetasql
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                bhulette Brian Hulette
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0h
                  0h
                  Logged:
                  Time Spent - 1h 50m
                  1h 50m