[jira] [Commented] (DRILL-1031) TPCH Query 5 returns wrong result for a scale factor of 10GB

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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

Rahul Challapalli commented on DRILL-1031:
------------------------------------------

Verified that the issue has been fixed but did not add the testcase yet

> 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
>             Fix For: 0.4.0
>
>
> 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.3.4#6332)