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/29 21:49:06 UTC
[jira] [Closed] (DRILL-1483) Tpch Query 10 fails for SF 100 over
parquet with precision issues
[ https://issues.apache.org/jira/browse/DRILL-1483?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli closed DRILL-1483.
------------------------------------
Verified
> 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)
> 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)