[jira] [Comment Edited] (DRILL-1036) TPCH Query 12 fails with result set validation for a scale factor of 10 GB

["Rahul Challapalli (JIRA)" <ji...@apache.org>]

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