hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harish Butani (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-5552) Merging of QBJoinTrees doesn't handle filter pushdowns correctly
Date Tue, 15 Oct 2013 23:31:42 GMT
Harish Butani created HIVE-5552:
-----------------------------------

             Summary: 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)

Mime
View raw message