[jira] Commented: (HIVE-1534) Join filters do not work correctly with outer joins

["Namit Jain (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/HIVE-1534?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12907001#action_12907001 ] 

Namit Jain commented on HIVE-1534:
----------------------------------

Definitely a bug, but not related to https://issues.apache.org/jira/browse/HIVE-1538.

For outer joins, the filters should not be pushed above the join.


For the query,

SELECT * FROM input3 a left outer JOIN input3 b ON (a.key=b.key AND a.key < 100);" 


the row: 100 100

is being pruned even before it reaches the join.

As you suggested above,  the correct solution is to have the filter as part of the join, which we dont support currently.

For now, I would suggest not supporting filters in the join condition for outer joins, since we are returning wrong results,
and the correct fix will involve a big change

> 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
>
>  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.