hello all, hope you are doing well! I would like to use aggregation functions in Pinot, such as dense_rank() or rank() but I am not able to find any documentation about that. Is it supported in Pinot ?

It is currently not supported, you may file a GH issue. Could you elaborate on the use case?