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