[
https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14705585#comment-14705585
]
Victoria Markman commented on DRILL-3677:
-----------------------------------------
Same with lag. Please let me know if you need lag case as well.
> 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 error.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
