Victoria Markman created DRILL-3677:
---------------------------------------
Summary: 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
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.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
