Re: OVER IGNORE NULLS support

Seems like IGNORE NULL is specified in SQL spec 2008 (paragraph 6.10), the opposite is called RESPECT NULLS: ::= RESPECT NULLS | IGNORE NULLS Perhaps this is worth supporting, I've opened an issue for that FLINK-24499 . @Adrian are you

Re: OVER IGNORE NULLS support

Hi! Currently all built-in aggregate functions ignore null input values, so I guess this is the reason why Flink didn't support this syntax. I'm sort of curious about this syntax. Does it come from the SQL standard? What's the opposite of IGNORE NULLS? Is there a NOT IGNORE NULLS and if the user

OVER IGNORE NULLS support

Hi, we've been trying to run a query similar to SELECT id, type, LAG(id) IGNORE NULLS OVER (PARTITION BY type ORDER BY ts) AS lastId FROM Events A query without IGNORE NULLS clause executes just fine. This syntax is supported by Calcite and our clients expect it to work. Our platform uses