[jira] [Commented] (HIVE-5552) Merging of QBJoinTrees doesn't handle filter pushdowns correctly

["Ashutosh Chauhan (JIRA)" <ji...@apache.org>]

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

Ashutosh Chauhan commented on HIVE-5552:
----------------------------------------

Harish, left some comments on RB. Also, once you update the patch, also upload it here so that HiveQA gets to run on it.

> Merging of QBJoinTrees doesn't handle filter pushdowns correctly
> ----------------------------------------------------------------
>
>                 Key: HIVE-5552
>                 URL: https://issues.apache.org/jira/browse/HIVE-5552
>             Project: Hive
>          Issue Type: Bug
>          Components: Query Processor
>            Reporter: Harish Butani
>            Assignee: Harish Butani
>
> The following query fails:
> (this based on the schema from auto_join_filters.q)
> {noformat}
> explain
> SELECT sum(hash(a.key,a.value,b.key,b.value)) 
> FROM myinput1 a LEFT OUTER JOIN myinput1 b on a.value = b.value  RIGHT OUTER JOIN myinput1 c 
>      ON 
>         b.value = c.value AND 
>         a.key > 40
> {noformat}
> Whereas this query succeeds
> {noformat}
> explain
> SELECT sum(hash(a.key,a.value,b.key,b.value)) 
> FROM myinput1 a LEFT OUTER JOIN myinput1 b RIGHT OUTER JOIN myinput1 c 
>      ON  a.value = b.value and
>         b.value = c.value AND 
>         a.key > 40
> {noformat}
> Pushing the first condition to the first join, triggers a merge of the 2 QBJoinTrees. During merge all the right side  filters identified for pushing are assumed to refer to the merging table (b in this case). But the pushable filters can refer to any left table.



--
This message was sent by Atlassian JIRA
(v6.1#6144)