Mailing-List: contact issues-help@drill.incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.incubator.apache.org
Date: Thu, 24 Jul 2014 16:38:38 +0000 (UTC)
From: "Rahul Challapalli (JIRA)" <jira@apache.org>
To: issues@drill.incubator.apache.org
Message-ID: <JIRA.12729493.1406219855176.38446.1406219918668@arcas>
In-Reply-To: <JIRA.12729493.1406219855176@arcas>
References: <JIRA.12729493.1406219855176@arcas>
Subject: [jira] [Updated] (DRILL-1184) TPCH Query 19 on top of text data
 (0.01 GB) does not match the baselines generated through postgres
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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

Rahul Challapalli updated DRILL-1184:
-------------------------------------

    Attachment: views.txt

> TPCH Query 19 on top of text data (0.01 GB) does not match the baselines generated through postgres
> ---------------------------------------------------------------------------------------------------
>
>                 Key: DRILL-1184
>                 URL: https://issues.apache.org/jira/browse/DRILL-1184
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow, Storage - Text & CSV
>            Reporter: Rahul Challapalli
>         Attachments: views.txt
>
>
> git.commit.id.abbrev=e5c2da0
> Query : 
> select
>   sum(l.l_extendedprice* (1 - l.l_discount)) as revenue
> from
>   lineitem l,
>   part p
> where
>   p.p_partkey = l.l_partkey
>   and (
>   (
>     p.p_brand = 'Brand#41'
>     and p.p_container in ('SM CASE', 'SM BOX', 'SM PACK', 'SM PKG')
>     and l.l_quantity >= 2 and l.l_quantity <= 2 + 10
>     and p.p_size between 1 and 5
>     and l.l_shipmode in ('AIR', 'AIR REG')
>     and l.l_shipinstruct = 'DELIVER IN PERSON'
>   )
>   or
>   (
>     p.p_brand = 'Brand#13'
>     and p.p_container in ('MED BAG', 'MED BOX', 'MED PKG', 'MED PACK')
>     and l.l_quantity >= 14 and l.l_quantity <= 14 + 10
>     and p.p_size between 1 and 10
>     and l.l_shipmode in ('AIR', 'AIR REG')
>     and l.l_shipinstruct = 'DELIVER IN PERSON'
>   )
>   or
>   (
>     p.p_brand = 'Brand#55'
>     and p.p_container in ('LG CASE', 'LG BOX', 'LG PACK', 'LG PKG')
>     and l.l_quantity >= 23 and l.l_quantity <= 23 + 10
>     and p.p_size between 1 and 15
>     and l.l_shipmode in ('AIR', 'AIR REG')
>     and l.l_shipinstruct = 'DELIVER IN PERSON'
>   ))
> Results :
>   - Drill : 108600
>   - Postgres : 106598.6290
> Attached the DDL for the views created before running this query.


--
This message was sent by Atlassian JIRA
(v6.2#6252)