Hi. Team.
https://docs.pinot.apache.org/developers/advanced/ingestion-level-transformations
In my tests, I had to use the groovy syntax used in the 'injection transformation filterFunction' differently for the realtime table and the offline table.
I don't know if this is a bug or wrong use case or the correct case, but I do report it as it seems confusing to users.
• 'score' field's datatype is float.
• 'filterFunction" : "Groovy({score >= 4 && score < 6}, score)" REALTIME working, OFFLINE not working(casting exception, creationAndPush injestion job)
• 'filterFunction" : "Groovy({(score as float) >= 4 && (score as float) < 6}, score)" OFFLINE working