drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Ramana Inukonda Nagaraj (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-999) TPCH 9 returns less rows than expected for SF 0.01
Date Mon, 16 Jun 2014 23:24:01 GMT

    [ https://issues.apache.org/jira/browse/DRILL-999?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14033166#comment-14033166
] 

Ramana Inukonda Nagaraj commented on DRILL-999:
-----------------------------------------------

As of
git.commit.id.abbrev=f86639c
it appears worse,

drill returns 14 rows as opposed to postgres which returns 175 rows.


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

Mime
View raw message