Window function + Multiple simultaneous aggregations

KarthikeyanB
New Contributor II

Hi team,

Why is there no support to perform multiple aggregations together with a single window spec? ie I dont want to specify each aggregation separately and I don't want to see each aggregation perform as a separate piece of work.

Or if there is indeed a way (other than say UDF), please do enlighten me.

Please advise.

KarthikeyanB
New Contributor II

Hi @Kaniz Fatma​ ,

Firstly, thank you much for responding.

Thank you for confirming that performing multiple aggr using a single window spec does NOT evaluate the window spec separately each time. My bad in the wrong understanding prior.