Apache Pinot

Hi guys, how can I cast a value from string to float? For some reason in the JSON results I'm getting strings as results from my `sum()`s, and I need them to be converted to floats, but I'd like to avoid having to reprocess this.

Oh, actually there's a `cast` function but somehow it's not working in my queries, how weird...

I get: `java.lang.IllegalArgumentException: Unsupported function: cast not found`

Looks like a genuine bug, I opened a ticket for it: <https://github.com/apache/pinot/issues/8977>

Just updated the ticket - this issue only happens in the incubator UI, I don't need to cast the numbers to float at all, they're already coming as float for me when querying from the outside via the Broker query API :slightly_smiling_face: