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/20 00:03:25 UTC

[jira] [Updated] (DRILL-1036) TPCH Query fails with result set validation for a scale factor of 10 GB

     [ https://issues.apache.org/jira/browse/DRILL-1036?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Rahul Challapalli updated DRILL-1036:
-------------------------------------

    Description: 
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 

  was:
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))


> TPCH Query 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)