Re: streaming query window operators

2024-02-09 Thread Julian Hyde
Your proposals will of course work. But they force the user to think in terms of a lower-level language. * TUMBLE is of course simple. Before we had TUMBLE we used "GROUP BY FLOOR(…)”. * HOP is a bit more complicated, because you need to create multiple copies of each row, each going into a

streaming query window operators

2024-02-09 Thread Mihai Budiu
Hello, I am not sure whether this is the right place to discuss this problem, but I don't know a better one. I am looking at the streaming extensions TUMBLE and HOP. I wonder why they require multiple functions and table functions each. It looks to me like they can be implemented in a much