[
https://issues.apache.org/jira/browse/HIVE-17766?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16223084#comment-16223084
]
Jesus Camacho Rodriguez commented on HIVE-17766:
------------------------------------------------
[~ashutoshc], some of these failures were legit. I have uploaded a new patch
and updated RB. Could you take a look? The main problem was in the logic that
generates the right input for the left semijoin. I had to do some work to
propagate the aliases correctly till the join operator, otherwise the execution
would fail when we try to parse the residual predicates in the join as column
references cannot be resolved.
> Support non-equi LEFT SEMI JOIN
> -------------------------------
>
> Key: HIVE-17766
> URL: https://issues.apache.org/jira/browse/HIVE-17766
> Project: Hive
> Issue Type: Improvement
> Components: Query Planning
> Reporter: Vineet Garg
> Assignee: Jesus Camacho Rodriguez
> Attachments: HIVE-17766.01.patch, HIVE-17766.02.patch,
> HIVE-17766.patch
>
>
> Currently we get an error like {noformat}Non equality condition not supported
> in Semi-Join{noformat}
> This is required to generate better plan for EXISTS/IN correlated subquery
> where such queries are transformed into LEFT SEMI JOIN.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
