0

Looking at the docs Create continuous view it's possible to create something like

CREATE CONTINUOUS VIEW cv AS
  SELECT
    ticketid,
    status,
    avg(status_duration) OVER w
  FROM stream
  WINDOW w AS (PARTITION BY ticketid);

But I get the error

ERROR: continuous queries don't support WINDOW functions

Am I misunderstanding the docs? Can someone clarify how window functions can be used in continuous views?

Thanks

AnaG
  • 17
  • 1
  • 5
  • That's a bug in the docs, sorry about that. We'll update the docs shortly. Support for window functions in continuous views was removed a few releases ago. – Derek Nelson Apr 04 '17 at 01:57
  • Is there some blog post about the reason that led to the removal of window functions in continuous views? Thanks. – AnaG Apr 04 '17 at 08:26
  • 1
    There isn't a blog post, no. The reason they were removed is that internally they require special casing all throughout the core engine, and nobody was using them so those code paths weren't providing much benefit to anyone. It's possible that we'll introduce them again in the future if users generally want them. – Derek Nelson Apr 05 '17 at 15:26

0 Answers0