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