How do I cast a string value to int or long using sql in pin Apache Pinot #general

How do I cast a string value to int or long using ...

troywinter

05/13/2021, 3:12 AM

How do I cast a string value to int or long using sql in pinot?

Jackie

05/13/2021, 4:17 AM

Are you planning to aggregate on it? If so, it should be auto-casted

Jackie

05/13/2021, 4:18 AM

E.g.

select sum(numericStringCol) from myTable

troywinter

05/13/2021, 6:00 AM

I see, but this is a multivalue column, I got it working by using groovy udf.