[
https://issues.apache.org/jira/browse/DRILL-1211?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jacques Nadeau updated DRILL-1211:
----------------------------------
Fix Version/s: 0.5.0
> Tpch query 3 over text data (SF 0.01) fails with a verification issue
> ---------------------------------------------------------------------
>
> Key: DRILL-1211
> URL: https://issues.apache.org/jira/browse/DRILL-1211
> Project: Apache Drill
> Issue Type: Bug
> Components: Execution - Flow, Storage - Text & CSV
> Reporter: Rahul Challapalli
> Fix For: 0.5.0
>
> Attachments: actual.tsv, expected.tsv
>
>
> git.commit.id.abbrev=caa8b78
> select
> l.l_orderkey,
> sum(l.l_extendedprice * (1 - l.l_discount)) as revenue,
> o.o_orderdate,
> o.o_shippriority
> from
> customer c,
> orders o,
> lineitem l
> where
> c.c_mktsegment = 'HOUSEHOLD'
> and c.c_custkey = o.o_custkey
> and l.l_orderkey = o.o_orderkey
> and o.o_orderdate < date '1995-03-25'
> and l.l_shipdate > date '1995-03-25'
> group by
> l.l_orderkey,
> o.o_orderdate,
> o.o_shippriority
> order by
> revenue desc,
> o.o_orderdate
> limit 10
> I attached the expected and actual files
--
This message was sent by Atlassian JIRA
(v6.2#6252)
