hi , is there a way to set

count(a) / count(b)

to 0 when

count(b) = 0

instead of

NaN

or

Infinity

?

Nan

and

Infinity

isn’t really sort friendly.

You can try case when syntax ?

yea,that’s the first thing I tried, error says case when doesn’t support aggregate function

this is a post aggregate scalar function

@ScalarFunction
  public static double divide(double a, double b) {
    return a / b;
  }

thanks Kishore , if there is an open issue/work item for this, it would be great if you can share the link here?

Will the post aggregation FILTER clause help here? cc: @Jackie

we dont want to filter those results out, this divide is usually a common use case of answering query for month over month change

we dont have an open item, its a simple function to add.. you can try it out and contribute

sure, sounds good

Ideally this should be solved with the

case

function, which is not supported on post-aggregation yet

created a PR https://github.com/apache/pinot/pull/9196

Afaik, 0.11 is already in progress, so the one after that.

around end of this year for 0.12?

Hopefully before that

hey friends kinda reviving this, we are in

0.11

and are facing this issue, what can we do to over come this? @Mayank @Jackie use DIVIDE() with denominator being 0.