Aggregate window functions support


#1

Hi,

Does MapD Core provide support for aggregate window functions using the OVER clause?

What would be the most performant way right now to implement a rolling aggregate in SQL against MapD Core?

Thanks!


#2

Hi @malv,

Currently MapD Core does not support window functions although it is something we would like to add in the future.

Your best bet as of now, if the cardinalities are feasible, might be to retrieve the result set from a query and do the roll-up client side.

Regards


#3

Thanks so much for the reply. Unfortunately we have too many rows to perform the operation on the client.

We tried different options, and we ended up doing it old-school by having a separate table with the different rolling periods, and the performance is amazing.

Thanks again!