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/05/02 00:02:06 UTC
[jira] [Closed] (DRILL-1184) TPCH Query 19 on top of text data
(0.01 GB) does not match the baselines generated through postgres
[ https://issues.apache.org/jira/browse/DRILL-1184?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli closed DRILL-1184.
------------------------------------
Verified! Below is the testcase
Functional/Passing/tpch0.01/text_double/19.q
Functional/Passing/tpch0.01/text_decimal/19.q
> 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
> Assignee: Steven Phillips
> Fix For: 0.5.0
>
> 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.3.4#6332)