drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Victoria Markman (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-3677) Wrong result with LEAD window function when used in multiple windows in the same query
Date Thu, 20 Aug 2015 18:10:46 GMT
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)

Mime
View raw message