Hello Pinot community, long time no see 🙂 Is there any way for

SUM

to not return 0 when there's actually no values to aggregate ? i.e. return

null

in such case

Long time no see @User. Do you mean no rows selected, or rows selected are null?

Good question I was thinking when there's no row selected

Then the result should be empty iirc

I remember asking this same question (couldn't find it back) and someone answered with a link to Pinot docs showing that aggregations have some kind of default values

Yeah that seems to be the case, which is different from what I recall. @User didn’t we use to return empty results in such cases?

No, for each aggregation function, there is a default value if no record is selected

Yeah that's what I remembered, thanks @User Mind sharing the associated docs ? Couldn't find it back 😶

Seems the doc has been updated and I cannot find it either 😅

I was sure it already existed lol

@User https://docs.pinot.apache.org/users/user-guide-query/supported-aggregations

Perfect Thanks @User !

I think it is the agrr+group by that returns empty results if no records selected.