[ https://issues.apache.org/jira/browse/DRILL-1031?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli closed DRILL-1031. ------------------------------------ > 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)