optimizer: add null predicate pruning for overwindow.

risingwavelabs / risingwave

Best-in-class stream processing, analytics, and management. Perform continuous analytics, or build event-driven applications, real-time ETL pipelines, and feature stores in minutes. Unified streaming and batch. PostgreSQL compatible.

https://go.risingwave.com/slack

Apache License 2.0

7.06k stars 581 forks source link

optimizer: add null predicate pruning for overwindow. #19437

Open kwannoel opened 3 days ago

kwannoel commented 3 days ago

If we have a row_number is null predicate, we can remove it. This can let the OverWindow be converted to GroupTopN.