You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@calcite.apache.org by "Chunwei Lei (JIRA)" <ji...@apache.org> on 2019/04/26 13:35:00 UTC

[jira] [Commented] (CALCITE-337) Support IGNORE NULLS in window aggregates

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

Chunwei Lei commented on CALCITE-337:
-------------------------------------

Duplicate with [CALCITE-883|https://issues.apache.org/jira/browse/CALCITE-883].

> Support IGNORE NULLS in window aggregates
> -----------------------------------------
>
>                 Key: CALCITE-337
>                 URL: https://issues.apache.org/jira/browse/CALCITE-337
>             Project: Calcite
>          Issue Type: Improvement
>            Reporter: Vladimir Sitnikov
>            Priority: Major
>
> Some of the functions are a bit more useful when they support IGNORE/RESPECT NULLS clause.
> For instance, FIRST_VALUE, LAST_VALUE, LEAD, LAG run in RESPECT NULLS by default. In IGNORE NULLS mode FIRST_VALUE calculates first not null value in the partiton.
> [Ignore nulls behaviour can be simulated|http://rwijk.blogspot.ru/2010/06/simulating-laglead-ignore-nulls.html] however it makes sense to support it. 
> Here's Oracle DB documentation on the subject: http://docs.oracle.com/cd/E16655_01/server.121/e17209/functions073.htm



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)