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:30:39 UTC
[jira] [Updated] (DRILL-1210) Tpch query 10 over text data (SF
0.01) fails with a verification issue
[ https://issues.apache.org/jira/browse/DRILL-1210?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Rahul Challapalli updated DRILL-1210:
-------------------------------------
Attachment: actual.tsv
expected.tsv
> 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
> 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.2#6252)