[
https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15852249#comment-15852249
]
Ashutosh Chauhan commented on HIVE-15458:
-----------------------------------------
Patch looks good. I think we can also incorporate additional improvement of
removing semijoin altogether if there is a Left Join at the top. LJ (left, Gby)
becomes left.
Ref:
https://github.com/apache/calcite/commit/565d639261d126462a78e57ff7f21527f38697a9#diff-d805aca283185d18d9cced7bd51b2390R120
> Fix semi-join conversion rule for subquery
> ------------------------------------------
>
> Key: HIVE-15458
> URL: https://issues.apache.org/jira/browse/HIVE-15458
> Project: Hive
> Issue Type: Sub-task
> Components: Logical Optimizer
> Reporter: Vineet Garg
> Assignee: Vineet Garg
> Attachments: HIVE-15458.1.patch
>
>
> Subquery code in *CalcitePlanner* turns off *hive.enable.semijoin.conversion*
> since it doesn't work for subqueries.
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
