Jesus Camacho Rodriguez created HIVE-21006: ----------------------------------------------
Summary: Extend SharedWorkOptimizer to remove semijoins when there is a reutilization opportunity Key: HIVE-21006 URL: https://issues.apache.org/jira/browse/HIVE-21006 Project: Hive Issue Type: Improvement Components: Physical Optimizer Reporter: Jesus Camacho Rodriguez Assignee: Jesus Camacho Rodriguez 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. -- This message was sent by Atlassian JIRA (v7.6.3#76005)