You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2014/06/19 23:55:26 UTC
[jira] [Comment Edited] (DRILL-1031) TPCH Query 5 returns wrong
result for a scale factor of 10GB
[ https://issues.apache.org/jira/browse/DRILL-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14037902#comment-14037902 ]
Rahul Challapalli edited comment on DRILL-1031 at 6/19/14 9:55 PM:
-------------------------------------------------------------------
Build # 26145
The number of rows match but the data shows some variation.
****************ACTUAL**********************
UNITED KINGDOM 4.285825077897988E8
RUSSIA 4.307360096898987E8
FRANCE 4.194159093639E8
GERMANY 4.3344250900630254E8
ROMANIA 4.209556496298005E8
******************EXPECTED********************
ROMANIA 5.293820481238E8 (1 time(s))
UNITED KINGDOM 5.305857480797E8 (1 time(s))
RUSSIA 5.332309387283E8 (1 time(s))
GERMANY 5.371937515695E8 (1 time(s))
FRANCE 5.227247546461E8
was (Author: rkins):
Build # 26145
The number of rows match but the data shows some variation.
****************EXPECTED**********************
UNITED KINGDOM 4.285825077897988E8
RUSSIA 4.307360096898987E8
FRANCE 4.194159093639E8
GERMANY 4.3344250900630254E8
ROMANIA 4.209556496298005E8
******************ACTUAL********************
ROMANIA 5.293820481238E8 (1 time(s))
UNITED KINGDOM 5.305857480797E8 (1 time(s))
RUSSIA 5.332309387283E8 (1 time(s))
GERMANY 5.371937515695E8 (1 time(s))
FRANCE 5.227247546461E8
> TPCH Query 5 returns wrong result for a scale factor of 10GB
> ------------------------------------------------------------
>
> Key: DRILL-1031
> URL: https://issues.apache.org/jira/browse/DRILL-1031
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Rahul Challapalli
>
> The below query fails during validation for a data volume of 10GB. However the same query works for a data volume of 1GB. The baselines have been generated using Postgres. Let me know if you need more details about the data and baselines.
> select
> n.n_name,
> sum(l.l_extendedprice * (1 - l.l_discount)) as revenue
> from
> customer c,
> orders o,
> lineitem l,
> supplier s,
> nation n,
> region r
> where
> c.c_custkey = o.o_custkey
> and l.l_orderkey = o.o_orderkey
> and l.l_suppkey = s.s_suppkey
> and c.c_nationkey = s.s_nationkey
> and s.s_nationkey = n.n_nationkey
> and n.n_regionkey = r.r_regionkey
> and r.r_name = 'EUROPE'
> and o.o_orderdate >= date '1997-01-01'
> and o.o_orderdate < date '1997-01-01' + interval '1' year
> group by
> n.n_name
> order by
> revenue desc
--
This message was sent by Atlassian JIRA
(v6.2#6252)