You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Jacques Nadeau (JIRA)" <ji...@apache.org> on 2014/07/15 20:56:04 UTC
[jira] [Resolved] (DRILL-999) TPCH 9 returns less rows than
expected for SF 0.01
[ https://issues.apache.org/jira/browse/DRILL-999?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Jacques Nadeau resolved DRILL-999.
----------------------------------
Resolution: Fixed
> TPCH 9 returns less rows than expected for SF 0.01
> --------------------------------------------------
>
> Key: DRILL-999
> URL: https://issues.apache.org/jira/browse/DRILL-999
> Project: Apache Drill
> Issue Type: Bug
> Components: Query Planning & Optimization
> Reporter: Ramana Inukonda Nagaraj
>
> TPCH 9 on drill returns 63 rows in drill vs 175 rows for postgres.
> /root/drillAutomation/testing/framework/resources/tpch-complete/testcases/09.sql : -- tpch9 using 1395599672 as a seed to the RNG
> select
> nation,
> o_year,
> sum(amount) as sum_profit
> from
> (
> select
> n.n_name as nation,
> extract(year from o.o_orderdate) as o_year,
> l.l_extendedprice * (1 - l.l_discount) - ps.ps_supplycost * l.l_quantity as amount
> from
> part p,
> supplier s,
> lineitem l,
> partsupp ps,
> orders o,
> nation n
> where
> s.s_suppkey = l.l_suppkey
> and ps.ps_suppkey = l.l_suppkey
> and ps.ps_partkey = l.l_partkey
> and p.p_partkey = l.l_partkey
> and o.o_orderkey = l.l_orderkey
> and s.s_nationkey = n.n_nationkey
> and p.p_name like '%yellow%'
> ) as profit
> group by
> nation,
> o_year
> order by
> nation,
> o_year desc
--
This message was sent by Atlassian JIRA
(v6.2#6252)