Hi there. Is there a way to transform a string field to a double/float upon ingestion? I'm looking at the supported transform functions and do not see a function that supports this https://docs.pinot.apache.org/users/user-guide-query/supported-transformations

what sort of transformation? could you give an example? if your column is STRING datatype in the source but is actually umeric, and all you want to is that it be stored as double/float in Pinot, that should already work afaik. All you’d have to do is set the right dataType in Pinot schema. Pinot has a DataTypeTransformer which is automatically applied during ingestion

Ah it does look like this is the case. Yeah, my column is a STRING datatype but is actually a numeric value. Looks like the conversion is applied automatically during ingestion. Thanks!