drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Closed] (DRILL-1210) Tpch query 10 over text data (SF 0.01) fails with a verification issue
Date Fri, 01 May 2015 22:43:08 GMT

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

Rahul Challapalli closed DRILL-1210.
------------------------------------

Verified! Below is the testcase

Functional/Passing/tpch0.01/text_decimal/10.q

> Tpch query 10 over text data (SF 0.01) fails with a verification issue
> ----------------------------------------------------------------------
>
>                 Key: DRILL-1210
>                 URL: https://issues.apache.org/jira/browse/DRILL-1210
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow, Storage - Text & CSV
>            Reporter: Rahul Challapalli
>            Assignee: Rahul Challapalli
>             Fix For: 0.5.0
>
>         Attachments: actual.tsv, expected.tsv
>
>
> git.commit.id.abbrev=caa8b78
> 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
> I attached the expected and actual results. Let me know if you need anything else



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message