drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1035) Tpch query 10 fails with a data validation issue for a data volume of 1GB and 10GB
Date Thu, 19 Jun 2014 21:55:25 GMT

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

Mime
View raw message