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 2015/04/17 23:29:59 UTC

[jira] [Closed] (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:all-tabpanel ]

Rahul Challapalli closed DRILL-1035.
------------------------------------

Verified and added a testcase

> 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
>             Fix For: 0.4.0
>
>
> 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.3.4#6332)