[
https://issues.apache.org/jira/browse/HIVE-21006?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jesus Camacho Rodriguez updated HIVE-21006:
-------------------------------------------
Attachment: HIVE-21006.patch
> 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
> Attachments: HIVE-21006.patch
>
>
> 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)
