Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-35553 Improve correlated subqueries
  3. SPARK-36113

Unify the logic to handle COUNT bug for scalar and lateral subqueries

    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Open
    • Major
    • Resolution: Unresolved
    • 3.2.0
    • None
    • SQL
    • None

    Description

      Currently, for scalar subqueries, the logic to handle the count bug is in `RewriteCorrelatedScalarSubquery` (constructLeftJoins) while lateral subqueries rely on `DecorrelateInnerQuery` to handle the COUNT bug. 

      We should unify them without introducing additional left outer joins for scalar subqueries.

       

      Attachments

        Issue Links

          is related to

          Sub-task - The sub-task of the issue SPARK-43098 Should not handle the COUNT bug when the GROUP BY clause of a correlated scalar subquery is non-empty

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              allisonwang-db Allison Wang
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated: