[
https://issues.apache.org/jira/browse/DRILL-1035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14037981#comment-14037981
]
Steven Phillips commented on DRILL-1035:
----------------------------------------
Why are there only 10 rows? Shouldn't there be 20 for each? And some of the
rows actual rows seem to match the expected rows, except for a small difference
in floating point. For example,
actual:
421414 Customer#000421414 697292.9713999999 8002.31 KENYA
WcyqUtcKbCttHmWaxFQ4r 24-551-544-5915 foxes. blithely regular packages t
expected:
421414 Customer#000421414 697292.9714 8002.31 KENYA
WcyqUtcKbCttHmWaxFQ4r 24-551-544-5915 foxes. blithely regular packages t
Could you tell us what exactly is different between the two result sets?
> 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)
