Hello,
Does Pinot support defining a computed field (metric) based on a field that does not appear in the schema but exists in the ingestion message? This is a realtime table if that makes a difference.
n
Neha Pawar
05/11/2021, 1:22 PM
Yes this is supported
p
Pedro Silva
05/11/2021, 1:25 PM
So the transformationFunction can receive as a parameter a field that does not exist in the schema? Is there documentation on this use-case?
n
Neha Pawar
05/11/2021, 2:12 PM
Yes. If you have a function like bar="reverse(foo)", where bar is in the Pinot schema, but foo is not in the Pinot schema, it will work if foo is present in the source record. Pinot will look for all arguments to the function in the row
👍 1
Neha Pawar
05/11/2021, 2:12 PM
Dunno if this is specifically documented, there might be a mention on the page with the transform functions documentation