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] [Commented] (DRILL-3414) Window function on a null producing column of an outer join results in the wrong result
Date Mon, 29 Jun 2015 17:50:05 GMT

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

Victoria Markman commented on DRILL-3414:
-----------------------------------------

I'm working on a smaller reproduction.

> Window function on a null producing column of an outer join results in the wrong result
> ---------------------------------------------------------------------------------------
>
>                 Key: DRILL-3414
>                 URL: https://issues.apache.org/jira/browse/DRILL-3414
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Query Planning & Optimization
>    Affects Versions: 1.0.0
>            Reporter: Victoria Markman
>            Assignee: Jinfeng Ni
>            Priority: Critical
>              Labels: window_funcion
>         Attachments: j1.tar, j4.parquet, query.tar
>
>
> {code:sql}
> select
>         j4.c_boolean,
>         j4.c_date,
>         j4.c_integer,
>         sum(j4.c_integer) over (partition by j4.c_boolean order by j4.c_date, j4.c_integer)
> from    j1
>            left outer join
>            j4 on j1.c_integer = j4.c_integer
> order by 1,2,3;
> {code}
> If window function is on left side, query returns correct result.
> This works:
> {code:sql}
> select
>         j1.c_boolean,
>         j1.c_date,
>         sum(j1.c_integer) over (partition by j1.c_boolean order by j1.c_date)
> from
>         j1
>                 left outer join
>         j4 on j1.c_integer = j4.c_integer
> order by
>         1, 2;
> {code}
> Attached:
> 1. query.tar (q2.sql , q2.res (postgres output), q2.out (drill output) )
> 2. tables : j1.tar, j4.parquet



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

Mime
View raw message