drill-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Resolved] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query
Date Fri, 21 Aug 2015 01:19:46 GMT

     [ https://issues.apache.org/jira/browse/DRILL-3677?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Victoria Markman resolved DRILL-3677.
-------------------------------------
    Resolution: Invalid

> 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)

Mime
View raw message