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

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

Rahul Challapalli created DRILL-1031:
----------------------------------------

             Summary: 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)