Is there a way we can do mode calculation in Pinot ?

whats the use case? what do you want the result to be if there are multiple modes

For our business purpose, we want the smallest value.

dont think we have a udf for that right now

It would be hard for us to split the query into multiple queries, would it be possible to create a udf for the same ?

yes,