Hi team, we are seeing some Pinot query with avg function returning -Infinity when the where clause returns no records, is there a way to modify the query to return Null for this case?
x
Xiang Fu
09/29/2021, 6:26 AM
right now the avg function returns a java double value(not Double), so it’s able to make it a null for this
c
Carl
09/29/2021, 3:02 PM
Is it possible by changing the query or it has to be fixed from code base?