[jira] [Updated] (HIVE-21006) Extend SharedWorkOptimizer to remove semijoins when there is a reutilization opportunity

["Jesus Camacho Rodriguez (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-21006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jesus Camacho Rodriguez updated HIVE-21006:
-------------------------------------------
    Status: Patch Available  (was: In Progress)

> 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
>            Priority: Major
>
> 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)