[ https://issues.apache.org/jira/browse/CALCITE-337?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chunwei Lei resolved CALCITE-337. --------------------------------- Resolution: Duplicate Fix Version/s: 1.20.0 > 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 > Fix For: 1.20.0 > > > 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)