Hello! What does it mean when

-Infinity

is returned?

One possibility is that you have nulls in your data, that may have been replaced by int/long min

For Float, the default value for a dimension column is

Float.NEGATIVE_INFINITY

(see https://docs.pinot.apache.org/basics/components/schema#data-types). As @Mayank suggested, you want to define the column as metric in your schema so the default value is 0 (or explicitly exclude rows with null values in the query).

@Yash Agarwal ^^ are our columns defines as a metric?

Yes @Grace Walkuski the columns are defined as metric, will dig into it a bit.

Can you check if the column you are `sum`’ing is a dimension or a metric in the schema @Yash Agarwal?

Let me confirm.

I see. I think that is likely by design, to let the caller know that no rows were actually selected.