[TAJO-636] The number of TPC-H 10 query results are wrong.

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Cannot Reproduce
• Assignee: Unassigned
• Reporter: Hyoungjun Kim
• Created: 26/Feb/14 05:01
• Updated: 21/Apr/14 06:39
• Resolved: 21/Apr/14 06:39

Description

I testes bellowing TPC-H Q10 query(dData scale=100GB). The result of Tajo is 3,884,217 while the results of Hive is 3,884,218

select c_custkey, c_name, sum(l_extendedprice * (1 - l_discount)) as revenue, c_acctbal, n_name, c_address, c_phone, c_comment 
from customer  c 
join nation n on c.c_nationkey = n.n_nationkey 
join orders o on c.c_custkey = o.o_custkey 
     and o.o_orderdate >= '1993-10-01' and o.o_orderdate < '1994-01-01' 
join lineitem_100 l on l.l_orderkey = o.o_orderkey and l.l_returnflag = 'R' 
group by c_custkey, c_name, c_acctbal, c_phone, n_name, c_address, c_comment order by revenue desc

Issue Links

• is related to: TAJO-741 GreedyHeuristicJoinOrderAlgorithm removes some join pairs.