You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2014/06/19 23:55:25 UTC
[jira] [Commented] (DRILL-1035) Tpch query 10 fails with a data
validation issue for a data volume of 1GB and 10GB
[ https://issues.apache.org/jira/browse/DRILL-1035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14037961#comment-14037961 ]
Rahul Challapalli commented on DRILL-1035:
------------------------------------------
TPCH Query 10 :
select
c.c_custkey,
c.c_name,
sum(l.l_extendedprice * (1 - l.l_discount)) as revenue,
c.c_acctbal,
n.n_name,
c.c_address,
c.c_phone,
c.c_comment
from
customer c,
orders o,
lineitem l,
nation n
where
c.c_custkey = o.o_custkey
and l.l_orderkey = o.o_orderkey
and o.o_orderdate >= date '1994-03-01'
and o.o_orderdate < date '1994-03-01' + interval '3' month
and l.l_returnflag = 'R'
and c.c_nationkey = n.n_nationkey
group by
c.c_custkey,
c.c_name,
c.c_acctbal,
c.c_phone,
n.n_name,
c.c_address,
c.c_comment
order by
revenue desc
limit 20
> Tpch query 10 fails with a data validation issue for a data volume of 1GB and 10GB
> ----------------------------------------------------------------------------------
>
> Key: DRILL-1035
> URL: https://issues.apache.org/jira/browse/DRILL-1035
> 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. Sample failures for a TPCH volume of 10 GB are below. Let me know if you need more information regarding data/baselines used.
> ****************************ACTUAL**************************
> 806566 Customer#000806566 744400.4775000002 1157.27 GERMANY bc0lFgLW MSoU7qP5JKfHSRLXcYpp2DofKt6 17-762-230-9031ckages. express packages nod blithe
> 1498981 Customer#001498981 699077.1106999998 1686.82 ARGENTINA DfGOMYLhxUUle0i 11-220-202-7603 ironic platelets along the carefully final theodolites sleep carefully after the slyly specia
> 1390222 Customer#001390222 843353.1832000001 -172.69 FRANCE wkr8tZnzZfhTEW 16-679-821-8279 onic asymptotes breach even courts. slyly express platelets believe fluffily regular packages. even packa
> 175699 Customer#000175699 751500.1087000001 3024.05 ROMANIA zvg,fyV84IAc01qkSzqYUvi0aZ2OUhV5dc 29-201-730-1750ges use furiously slyly even dependencies. fluffily regular deposits affix around the accounts. blithely final depo
> 421414 Customer#000421414 697292.9713999999 8002.31 KENYA WcyqUtcKbCttHmWaxFQ4r 24-551-544-5915 foxes. blithely regular packages t
> 267589 Customer#000267589 709745.6194 7962.28 BRAZIL pBLsa5ZIu6Kp5VHvuDw9OGpAoedWW5qw 12-703-470-8926 ! ironic, ironic dolphins above the packages are around
> 1482700 Customer#001482700 733791.5307 8535.43 ROMANIA loC24OSzOaE1ehFq9gVfcDkBaMU3Ol,oO5k0GyV, 29-396-536-3548nag. furiously dogged ideas sle
> 685849 Customer#000685849 773890.4841000001 -349.36 JAPAN GHHIMBK4QnLhI 22-908-620-7455 the unusual dinos wake slyly blithely special deposits. slyly final platelets believe. ironi
> 179122 Customer#000179122 823933.2546000001 633.0 ETHIOPIA ImdwqdO1j0Xk 15-787-260-5708 the quickly unusual packages! furiously special packages across the carefully regular deposits are b
> 253957 Customer#000253957 688595.8053999998 7166.31 PERU gmIJK5vG6jEVF5,Pvb9FS 27-208-177-8701 ns sleep blithely unusual packages. slyly close patterns sleep alongside of the fl
> **********************EXPECTED************************
> 1415794 Customer#001415794 688181.9813 2303.88 ARGENTINA DAKoXGw,T5H1pJUEU7J5r6Lsj41Arzy 11-376-701-8484 ial ideas must have to sleep furiously final, regular requests. req (1 time(s))
> 24592 Customer#000024592 719379.4559 -237.48 ALGERIA VjwO4BC7FMKeJRGkKuBK 10-684-336-5808the furiously regular packages. (1 time(s))
> 421414 Customer#000421414 697292.9714 8002.31 KENYA WcyqUtcKbCttHmWaxFQ4r 24-551-544-5915 foxes. blithely regular packages t (1 time(s))
> 512893 Customer#000512893 708760.1433 931.37 RUSSIA 0lqXTy 0B0Eq 32-517-580-8327 ve the carefully regular deposits. quickly daring dolphins according to the fur (1 time(s))
> 806566 Customer#000806566 744400.4775 1157.27 GERMANY bc0lFgLW MSoU7qP5JKfHSRLXcYpp2DofKt6 17-762-230-9031 ckages. express packages nod blithe (1 time(s))
> 1171042 Customer#001171042 725999.0571 5621.08 RUSSIA Jtw5t7gpgh4WhnDYBHzUFcCndJ1GRO8Zft 32-707-858-6894 riously final theodolites integrate quickly even, bold package (1 time(s))
> 1139227 Customer#001139227 724106.7061 1624.44 RUSSIA ZwNhNlqIDtjVrII4JEXR 6YKMIV5nDXeVi8,T 32-962-252-1986 ke slyly blithely regular requests. close, regular requests nag furiously iro (1 time(s))
> 896674 Customer#000896674 690380.8468 9191.72 FRANCE hNm2ctwBIZKpirUSPxYHaIYY 16-579-318-4889 s use against the furiously regular accounts. pending deposits hagg (1 time(s))
> 685849 Customer#000685849 773890.4841 -349.36 JAPAN GHHIMBK4QnLhI 22-908-620-7455 the unusual dinos wake slyly blithely special deposits. slyly final platelets believe. ironi (1 time(s))
> 617845 Customer#000617845 689794.2434 -679.91 ARGENTINA D,uIwUtjB8NJa236c,fJXjZqDd1Ax3 11-749-861-5782 ular foxes. quickly ironic dependencies wake pending theodolites. bl (1 time(s))
--
This message was sent by Atlassian JIRA
(v6.2#6252)