hawq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lin Wen (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HAWQ-1616) Wrong Result of Hash Join When Enable Bloom filter
Date Thu, 24 May 2018 10:12:00 GMT
Lin Wen created HAWQ-1616:
-----------------------------

             Summary: Wrong Result of Hash Join When Enable Bloom filter
                 Key: HAWQ-1616
                 URL: https://issues.apache.org/jira/browse/HAWQ-1616
             Project: Apache HAWQ
          Issue Type: Bug
          Components: Query Execution
            Reporter: Lin Wen
            Assignee: Lei Chang


Wrong result of Hash Join when enable Bloom filter in some cases, e.g join key "l_partkey"
is not in select list:

select  l_quantity, l_partkey,  l_extendedprice  from part, lineitem where p_partkey = l_partkey
and p_brand = 'Brand#23' and p_container = 'MED BOX' limit 10; 

 select  l_quantity,  l_extendedprice  from part, lineitem where p_partkey = l_partkey and
p_brand = 'Brand#23' and p_container = 'MED BOX' limit 10;



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)

Mime
View raw message