Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-21006

Extend SharedWorkOptimizer to remove semijoins when there is a reutilization opportunity

    XMLWordPrintableJSON

Details

    Description

      Assume there are two TS operators in the plan over the same table, same columns, same conditions, etc.
      The first TS operator, TS1, has an incoming SJ edge. The second TS operator, TS2, does not have any incoming SJ edge.
      Since TS2 is reading the full table, we may just remove the SJ and TS1. Then we will keep and share TS2, since it reads all the data in any case.

      Attachments

        1. HIVE-21006.01.patch
          47 kB
          Jesus Camacho Rodriguez
        2. HIVE-21006.patch
          47 kB
          Jesus Camacho Rodriguez

        Issue Links

          Activity

            People

              jcamachorodriguez Jesus Camacho Rodriguez
              jcamachorodriguez Jesus Camacho Rodriguez
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: