[jira] [Created] (DRILL-999) TPCH 9 returns less rows than expected for SF 0.01

["Ramana Inukonda Nagaraj (JIRA)" <ji...@apache.org>]

Ramana Inukonda Nagaraj created DRILL-999:
---------------------------------------------

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