drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Deneche A. Hakim (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-3595) Wrong results returned by query that uses LEAD window function
Date Mon, 03 Aug 2015 22:36:05 GMT

    [ https://issues.apache.org/jira/browse/DRILL-3595?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14652687#comment-14652687
] 

Deneche A. Hakim commented on DRILL-3595:
-----------------------------------------

[~khfaraaz] can you please share the test file union_01 ?

> Wrong results returned by query that uses LEAD window function
> --------------------------------------------------------------
>
>                 Key: DRILL-3595
>                 URL: https://issues.apache.org/jira/browse/DRILL-3595
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Codegen, Execution - Flow
>    Affects Versions: 1.2.0
>         Environment: private-branch-new-window-funcs
>            Reporter: Khurram Faraaz
>            Assignee: Deneche A. Hakim
>
> Query that uses LEAD window function returns wrong results on developer's private branch
(new-window-funcs).
> Results returned by Drill
> {code}
> 0: jdbc:drill:schema=dfs.tmp> select lead(c1) over w from union_01 window w as (partition
by c3 order by c1) limit 10;
> +---------+
> | EXPR$0  |
> +---------+
> | 878     |
> | -150    |
> | 402     |
> | 402     |
> | 402     |
> | 402     |
> | 402     |
> | 160     |
> | 160     |
> | 160     |
> +---------+
> 10 rows selected (0.349 seconds)
> {code}
> Results returned by Postgres
> {code}
> postgres=# select lead(c1) over w from union_01 window w as (partition by c3 order by
c1) limit 10;
>  lead 
> ------
>      
>      
>   402
>   402
>   402
>   402
>   402
>      
>   160
>   160
> (10 rows)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message