Feature request: partitioning in moving aggregation node

Halo,

I've recently discovered the moving aggregation node and it's absolutely brilliant!

But, would it be very difficult to add partitioning to the node? (are there any plans to do so?) That would be super helpful, especially with cumulative computation, like cumsum groupped by columns. 

Something like, 

SELECT 
    DEPTNO,
    SALE,
    SUM(SALE) OVER (PARTITION BY DEPTNO) DEPTTOTAL

In Oracle

Group loop + Moving Aggregation is not efficient, and Java snippet I'm using now is fine, and fast, but would be quite ugly if I wanted to run multiple functions on multiple columns, especially partitioned by different subset of columns each. 

Your Rank node it's great, but it only provides ranking, no cumsum, or cumavg. 

Kind regards,

Joseph Strudel

Hi Joseph,

That is a great idea, thank you for suggesting this!

We have opened a feature request to implement this. If there are any news, we will let you know.

Cheers,

Roland

Hi RolandBurger,
Wondering if there is a new feature out to accomplish this task? I’m stuck on the same problem.
Thanks!

Hi supersharp,

No news here unfortunately! There is still an open request for this, but we can’t estimate yet when this will be implemented.

Cheers,
Roland