Window function + Multiple simultaneous aggregations
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-14-2023 08:01 AM
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.
Labels:
- Labels:
-
Udf
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-15-2023 03:00 AM
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.