drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1031) TPCH Query 5 returns wrong result for a scale factor of 10GB
Date Mon, 30 Jun 2014 20:10:25 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14048062#comment-14048062
] 

Jacques Nadeau commented on DRILL-1031:
---------------------------------------

fixed in 3ea8eb5 or earlier

> 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: Execution - Flow, 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)

Mime
View raw message