Uploaded image for project: 'Spark'
  1. Spark
  2. SPARK-25482

Fast equal can not check reuseSubquery when apply rule about ReuseSubquery

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Minor
    • Resolution: Fixed
    • 2.3.1
    • 3.0.0
    • Optimizer, SQL
    • None

    Description

      the datasource filter should be push down, so there will be two subquery on this query

      select count(1) from lineitem where i_partkey > (select max(p_partkey)-1000 from part)

      One of the subquery will apply a rule about ReuseSubquery and generate a new plan, but the new plan will be ignored by method fastEquals() and subquery will be executed two times.

      Attachments

        Activity

          People

            mgaido Marco Gaido
            hongnv110 GuangWeiHong
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: