hyoungjunkim created TAJO-636:
---------------------------------
Summary: The number of TPC-H 10 query results are wrong.
Key: TAJO-636
URL: https://issues.apache.org/jira/browse/TAJO-636
Project: Tajo
Issue Type: Bug
Reporter: hyoungjunkim
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
{code}
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
{code}
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)
