[jira] [Resolved] (DRILL-3414) Window function on a null producing column of an outer join results in the wrong result

["Victoria Markman (JIRA)" <ji...@apache.org>]

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

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

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