You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@tajo.apache.org by "Jaehwa Jung (JIRA)" <ji...@apache.org> on 2014/04/21 08:40:14 UTC
[jira] [Resolved] (TAJO-636) The number of TPC-H 10 query results
are wrong.
[ https://issues.apache.org/jira/browse/TAJO-636?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jaehwa Jung resolved TAJO-636.
------------------------------
Resolution: Cannot Reproduce
We cannot reproduce this bug any more.
> 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: Hyoungjun Kim
>
> 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.2#6252)