[
https://issues.apache.org/jira/browse/DRILL-1033?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14037925#comment-14037925
]
Rahul Challapalli commented on DRILL-1033:
------------------------------------------
Tpch Query 09 :
select
nation,
o_year,
sum(amount) as sum_profit
from
(
select
n.n_name as nation,
extract(year from o.o_orderdate) as o_year,
l.l_extendedprice * (1 - l.l_discount) - ps.ps_supplycost * l.l_quantity
as amount
from
part p,
supplier s,
lineitem l,
partsupp ps,
orders o,
nation n
where
s.s_suppkey = l.l_suppkey
and ps.ps_suppkey = l.l_suppkey
and ps.ps_partkey = l.l_partkey
and p.p_partkey = l.l_partkey
and o.o_orderkey = l.l_orderkey
and s.s_nationkey = n.n_nationkey
and p.p_name like '%yellow%'
) as profit
group by
nation,
o_year
order by
nation,
o_year desc
> Tpch query09 fails with a verification failure
> ----------------------------------------------
>
> Key: DRILL-1033
> URL: https://issues.apache.org/jira/browse/DRILL-1033
> Project: Apache Drill
> Issue Type: Bug
> Reporter: Rahul Challapalli
>
> git.commit.id.abbrev=894037a
> Build # : 26145
> This query fails for a volume of 1 GB and 10GB with verification issues.
> The total number of records returned match the expected number. However the
> contents do not match. Let me know if you want more information about the
> data/baselines used
> Sample variation for 10GB volume :
> **********************ACTUAL**********************
> CHINA 1993 3928782.7530000005
> IRAN 1994 3530144.0313999974
> CHINA 1994 3456309.568900001
> IRAN 1995 4076698.578900001
> IRAQ 1992 3731546.0713999993
> CHINA 1995 3369649.071999999
> INDIA 1998 2491042.2729000007
> IRAN 1996 4062439.517499999
> IRAQ 1993 4298698.9248
> CHINA 1996 4112591.2585999994
> ****************************EXPECTED**********************
> IRAN 1995.0 3.483284650333E8 (1 time(s))
> ARGENTINA 1994.0 3.549701593013E8 (1 time(s))
> BRAZIL 1998.0 2.069814244412E8 (1 time(s))
> FRANCE 1994.0 3.50087824318E8 (1 time(s))
> UNITED KINGDOM 1998.0 2.035614862279E8 (1 time(s))
> EGYPT 1992.0 3.490843079761E8 (1 time(s))
> MOZAMBIQUE 1993.0 3.385115303458E8 (1 time(s))
> IRAN 1993.0 3.484653974794E8 (1 time(s))
> FRANCE 1995.0 3.491320397015E8 (1 time(s))
> INDONESIA 1997.0 3.399028270854E8 (1 time(s))
--
This message was sent by Atlassian JIRA
(v6.2#6252)
