[DRILL-832] verification fails for hash join

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Relational Operators
• Assignee: Zhiyong Liu
• Reporter: Zhiyong Liu
• Created: 23/May/14 22:36
• Updated: 10/Jun/14 18:09
• Resolved: 10/Jun/14 18:09

Description

Datasources: TPCH (10MB), three-way split parquet files
git.commit.id.abbrev=92408f1
git.commit.id=92408f193043fa3049d114930a97ecf2332e08c0

A large amount of discrepant data for the following query:

2014-05-23 14:44:27 INFO DrillTestBase:275 - Submitting query:
/root/open-source-drill-test/testing/framework/resources/tpch-smoke/testcases/join10-hash.q : alter session set `planner.enable_mergejoin` = false
2014-05-23 14:44:27 INFO DrillTestBase:275 - Submitting query:
/root/open-source-drill-test/testing/framework/resources/tpch-smoke/testcases/join10-hash.q :
select o.O_TOTALPRICE
from customer c, orders o
where c.C_CUSTKEY = o.O_CUSTKEY