You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Lefty Leverenz (JIRA)" <ji...@apache.org> on 2016/09/06 23:39:21 UTC

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

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

Lefty Leverenz commented on HIVE-1534:
--------------------------------------

[~sladymon] documented the property *hive.outerjoin.supports.filters* in the wiki:

* [Configuration Properties - hive.outerjoin.supports.filters | https://cwiki.apache.org/confluence/display/Hive/Configuration+Properties#ConfigurationProperties-hive.outerjoin.supports.filters]

Thanks, Shannon.

> Join filters do not work correctly with outer joins
> ---------------------------------------------------
>
>                 Key: HIVE-1534
>                 URL: https://issues.apache.org/jira/browse/HIVE-1534
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Amareshwari Sriramadasu
>            Assignee: Amareshwari Sriramadasu
>             Fix For: 0.7.0
>
>         Attachments: patch-1534-1.txt, patch-1534-2.txt, patch-1534-3.txt, patch-1534-4.txt, 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 was sent by Atlassian JIRA
(v6.3.4#6332)