Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Cannot Reproduce
-
None
-
None
-
None
-
None
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
Attachments
Issue Links
- is related to
-
TAJO-741 GreedyHeuristicJoinOrderAlgorithm removes some join pairs.
- Resolved