[
https://issues.apache.org/jira/browse/HAWQ-1616?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lin Wen resolved HAWQ-1616.
---------------------------
Resolution: Fixed
Fix Version/s: 2.4.0.0-incubating
> 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: Lin Wen
> Priority: Major
> Fix For: 2.4.0.0-incubating
>
>
> 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;
> The SQL statement and data are from TPCH workload, the correct result should
> be:
> l_quantity | l_extendedprice
> ------------+-----------------
> 3.00 | 5399.55
> 6.00 | 8318.58
> 38.00 | 57927.20
> 49.00 | 90545.63
> 44.00 | 76197.88
> 10.00 | 17146.20
> 26.00 | 34376.94
> 35.00 | 56332.85
> 9.00 | 11999.88
> 14.00 | 24020.92
> (10 rows)
> The projection information hasn't been pushed down to parquet scan correctly,
> so current result is none.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
