[
https://issues.apache.org/jira/browse/HIVE-15458?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15849294#comment-15849294
]
Vineet Garg commented on HIVE-15458:
------------------------------------
cc [~ashutoshc]
I tried with cbo off for following query
{code:SQL} select p1.p_name from part p1 left semi join (select p.* from part
p, part pp where p.p_size = pp.p_size) p2 on p1.p_type = p2.p_type; {code}
to produce similar AST to observe how we deal with this in non-cbo, but HIVE
doesn't produce another JOIN underneath LEFT SEMI JOIN node. Probably we never
get into this situation with cbo off.
> 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
>
> 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)
