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)
