Snowshoe logo
all-things-risingwave

Is there a plan to support postgres-style window functions (OVER clause) in RisingWave?

I'm interested in knowing if there are plans to support postgres-style window functions (OVER clause) in RisingWave. The current TOP-N syntax isn't very practical and does not allow retrieving aggregate values as columns without a where clause. An example use case could be adding the last value by time bucket and performing return calculations on prices.

Jf

Jf p

Asked on Jun 29, 2023

  • Yes, there are plans to support postgres-style window functions (OVER clause) in RisingWave.
  • The feature is being tracked on GitHub at this link.
  • The implementation is expected to be completed in about a month.
  • Initially, streaming over window will be implemented in create mv or create sink, with batch version in query statement or DQL to follow.
  • For more updates, it's recommended to check the GitHub repository for progress.
Jun 29, 2023Edited by