[
https://issues.apache.org/jira/browse/HIVE-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12909182#action_12909182
]
Amareshwari Sriramadasu commented on HIVE-1534:
-----------------------------------------------
Thanks Namit for the feedback.
bq. One general comment was that you also need to account for progress if the
join filters filter all the rows.
This shouldn't be a problem because, even if the row is filtered, the join will
emit output by joining it with nulls. Am I sounding right?
I'm almost done with the next patch which fixes the bugs with right outer join,
full outer join and nested joins in the earlier patch. Will upload it once all
the tests pass.
> Join filters do not work correctly with outer joins
> ---------------------------------------------------
>
> Key: HIVE-1534
> URL: https://issues.apache.org/jira/browse/HIVE-1534
> Project: Hadoop Hive
> Issue Type: Bug
> Components: Query Processor
> Reporter: Amareshwari Sriramadasu
> Assignee: Amareshwari Sriramadasu
> Attachments: patch-1534.txt
>
>
> SELECT * FROM T1 LEFT OUTER JOIN T2 ON (T1.c1=T2.c2 AND T1.c1 < 10)
> and SELECT * FROM T1 RIGHT OUTER JOIN T2 ON (T1.c1=T2.c2 AND T2.c1 < 10)
> do not give correct results.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
