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 2014/07/28 20:22:39 UTC
[jira] [Updated] (DRILL-1208) Tpch Query 8 over text data (SF 0.01)
has a data verification issue
[ https://issues.apache.org/jira/browse/DRILL-1208?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli updated DRILL-1208:
-------------------------------------
Attachment: views.txt
> Tpch Query 8 over text data (SF 0.01) has a data verification issue
> -------------------------------------------------------------------
>
> Key: DRILL-1208
> URL: https://issues.apache.org/jira/browse/DRILL-1208
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow, Storage - Text & CSV
> Reporter: Rahul Challapalli
> Attachments: views.txt
>
>
> git.commit.id.abbrev=caa8b78
> Query 8 :
> select
> o_year,
> sum(case
> when nation = 'EGYPT' then volume
> else 0
> end) / sum(volume) as mkt_share
> from
> (
> select
> extract(year from o.o_orderdate) as o_year,
> l.l_extendedprice * (1 - l.l_discount) as volume,
> n2.n_name as nation
> from
> part p,
> supplier s,
> lineitem l,
> orders o,
> customer c,
> nation n1,
> nation n2,
> region r
> where
> p.p_partkey = l.l_partkey
> and s.s_suppkey = l.l_suppkey
> and l.l_orderkey = o.o_orderkey
> and o.o_custkey = c.c_custkey
> and c.c_nationkey = n1.n_nationkey
> and n1.n_regionkey = r.r_regionkey
> and r.r_name = 'MIDDLE EAST'
> and s.s_nationkey = n2.n_nationkey
> and o.o_orderdate between date '1995-01-01' and date '1996-12-31'
> and p.p_type = 'PROMO BRUSHED COPPER'
> ) as all_nations
> group by
> o_year
> order by
> o_year
> Failure Records :
> Postgres : 1995 0.2575147489116481
> Drill : 1995 0.2506000484442781
> Let me know if you need any more information
--
This message was sent by Atlassian JIRA
(v6.2#6252)