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)
