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] [Created] (DRILL-1483) Tpch Query 10 fails for SF 100 over parquet with precision issues
Date Thu, 02 Oct 2014 18:18:35 GMT
Rahul Challapalli created DRILL-1483:
----------------------------------------

             Summary: Tpch Query 10 fails for SF 100 over parquet with precision issues
                 Key: DRILL-1483
                 URL: https://issues.apache.org/jira/browse/DRILL-1483
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Data Types
            Reporter: Rahul Challapalli


git.commit.id.abbrev=5c220e3

The below query fails with verification issues. This looks like a regression since this is
passing with 0.5 release

{code}
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
{code}

Expected number of rows: 20
Actual number of rows from Drill: 20
Number of matching rows: 17
Number of rows missing: 3
Number of rows unexpected: 3

Actual Data from drill :
{code}
6372220	Customer#006372220	793123.1516000001	2836.62	FRANCE	bfd3hpM99xDp6AFsGNOPP	16-143-244-4177
 regular theodolites are according to the unusual 	
	14211121	Customer#014211121	796135.1836	7443.03	MOROCCO	ks7nhxDqzdk72CfWM	25-755-902-4219
lyly final packages doubt furiously carefully bold theodolites. final 	
	246700	Customer#000246700	801786.5193999999	5244.71	CHINA	o6FXqCXJjKy3JdCAvuU3XJNRFcz35rAoc
28-466-828-8872	 even asymptotes cajole slyly with the furiously bold accounts. furiously
unusual platelets believe quickly final,
{code}

Expected Data :
{code}
14211121	Customer#014211121	796135.1835999999	7443.03	MOROCCO	ks7nhxDqzdk72CfWM	25-755-902-4219
lyly final packages doubt furiously carefully bold theodolites. final    
	246700	Customer#000246700	801786.5194000001	5244.71	CHINA	o6FXqCXJjKy3JdCAvuU3XJNRFcz35rAoc
28-466-828-8872	 even asymptotes cajole slyly with the furiously bold accounts. furiously
unusual platelets believe quickly final,    
	6372220	Customer#006372220	793123.1516000001	2836.62	FRANCE	bfd3hpM99xDp6AFsGNOPP	16-143-244-4177
 regular theodolites are according to the unusual
{code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message