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