drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jacques Nadeau (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-1483) Tpch Query 10 fails for SF 100 over parquet with precision issues
Date Fri, 23 Jan 2015 16:37:34 GMT

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

Jacques Nadeau resolved DRILL-1483.
-----------------------------------
    Resolution: Fixed

> 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
>            Assignee: Daniel Barclay (Drill/MapR)
>            Priority: Critical
>             Fix For: 0.8.0
>
>
> 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