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

Posted to dev@calcite.apache.org by "Vladimir Sitnikov (JIRA)" <ji...@apache.org> on 2014/07/07 08:34:33 UTC

[jira] [Created] (OPTIQ-337) Support IGNORE NULLS in window aggregates

Vladimir Sitnikov created OPTIQ-337:
---------------------------------------

             Summary: Support IGNORE NULLS in window aggregates
                 Key: OPTIQ-337
                 URL: https://issues.apache.org/jira/browse/OPTIQ-337
             Project: Optiq
          Issue Type: Improvement
            Reporter: Vladimir Sitnikov
            Assignee: Julian Hyde


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
(v6.2#6252)