[
https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Victoria Markman updated DRILL-3677:
------------------------------------
Description:
Query produces wrong result:
{code}
select
c_integer,
lead(c_integer) over (order by c_integer),
lead(c_integer) over (partition by c_time order by c_date)
from
j1
;
{code}
Attached: q46.res (result generated from postgres)
q46.out (output from Drill)
j1.tar - table used in the query
I tried to reproduce the same error on a smaller data set without any success.
Tried with the table with the same data as j1, but single parquet file: same
behavior.
was:
Query produces wrong result:
{code}
select
c_integer,
lead(c_integer) over (order by c_integer),
lead(c_integer) over (partition by c_time order by c_date)
from
j1
;
{code}
Attached: q46.res (result generated from postgres)
q46.out (output from Drill)
j1.tar - table used in the query
I tried to reproduce the same error on a smaller data set without any success.
Tried with the table with the same data as j1, but single parquet file: same
error.
> Wrong result with LEAD window function when used in multiple windows in the
> same query
> --------------------------------------------------------------------------------------
>
> Key: DRILL-3677
> URL: https://issues.apache.org/jira/browse/DRILL-3677
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Affects Versions: 1.2.0
> Reporter: Victoria Markman
> Assignee: Deneche A. Hakim
> Priority: Critical
> Fix For: 1.2.0
>
> Attachments: j1.tar, q46.out, q46.res
>
>
> Query produces wrong result:
> {code}
> select
> c_integer,
> lead(c_integer) over (order by c_integer),
> lead(c_integer) over (partition by c_time order by c_date)
> from
> j1
> ;
> {code}
> Attached: q46.res (result generated from postgres)
> q46.out (output from Drill)
> j1.tar - table used in the query
> I tried to reproduce the same error on a smaller data set without any
> success. Tried with the table with the same data as j1, but single parquet
> file: same behavior.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
