[
https://issues.apache.org/jira/browse/DRILL-999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14033155#comment-14033155
]
Steven Phillips commented on DRILL-999:
---------------------------------------
Please always include the git.commit info.
Was this found with the latest master (as of 1:51 pm)?
> 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)
