drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Mehant Baid (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1208) Tpch Query 8 over text data (SF 0.01) has a data verification issue
Date Mon, 28 Jul 2014 18:28:40 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1208?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14076544#comment-14076544
] 

Mehant Baid commented on DRILL-1208:
------------------------------------

The view is created using decimal data type for some columns, is that the case for the postgres
tables as well or is it created as a double data type?

> 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)

Mime
View raw message