drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Comment Edited] (DRILL-1036) TPCH Query 12 fails with result set validation for a scale factor of 10 GB
Date Thu, 19 Jun 2014 22:05:24 GMT

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

Rahul Challapalli edited comment on DRILL-1036 at 6/19/14 10:04 PM:
--------------------------------------------------------------------

Tpch Query 12 :

select
  l.l_shipmode,
  sum(case
    when o.o_orderpriority = '1-URGENT'
      or o.o_orderpriority = '2-HIGH'
      then 1
    else 0
  end) as high_line_count,
  sum(case
    when o.o_orderpriority <> '1-URGENT'
      and o.o_orderpriority <> '2-HIGH'
      then 1
    else 0
  end) as low_line_count
from
  orders o,
  lineitem l
where
  o.o_orderkey = l.l_orderkey
  and l.l_shipmode in ('TRUCK', 'REG AIR')
  and l.l_commitdate < l.l_receiptdate
  and l.l_shipdate < l.l_commitdate
  and l.l_receiptdate >= date '1994-01-01'
  and l.l_receiptdate < date '1994-01-01' + interval '1' year
group by
  l.l_shipmode
order by
  l.l_shipmode


was (Author: rkins):
select
  l.l_shipmode,
  sum(case
    when o.o_orderpriority = '1-URGENT'
      or o.o_orderpriority = '2-HIGH'
      then 1
    else 0
  end) as high_line_count,
  sum(case
    when o.o_orderpriority <> '1-URGENT'
      and o.o_orderpriority <> '2-HIGH'
      then 1
    else 0
  end) as low_line_count
from
  orders o,
  lineitem l
where
  o.o_orderkey = l.l_orderkey
  and l.l_shipmode in ('TRUCK', 'REG AIR')
  and l.l_commitdate < l.l_receiptdate
  and l.l_shipdate < l.l_commitdate
  and l.l_receiptdate >= date '1994-01-01'
  and l.l_receiptdate < date '1994-01-01' + interval '1' year
group by
  l.l_shipmode
order by
  l.l_shipmode

> TPCH Query 12 fails with result set validation for a scale factor of 10 GB
> --------------------------------------------------------------------------
>
>                 Key: DRILL-1036
>                 URL: https://issues.apache.org/jira/browse/DRILL-1036
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>            Reporter: Rahul Challapalli
>
> git.commit.id.abbrev=894037a
> Build # : 26145
> The number of rows returned matches the expected value. However the actual data in the
row does not match. Below are the failures. Let me know if you need more information regarding
data/baselines used.
> ****************************ACTUAL**************************
> TRUCK	57506	86188
> REG AIR	57675	85976
> *************************EXPECTED*****************************
> TRUCK     	62209	93246 (1 time(s))
> REG AIR   	62545	93026 



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message