Hi there, with 0.8.0, Pinot has got the complex type support as per https://docs.pinot.apache.org/basics/data-import/complex-type. My question is: can the unnested fields like “group.group_topics.urlkey” in the meetupRsvp example be supplied as arguments to the transform functions? The answer seems to be No in my testing.

you can use json functions - https://docs.pinot.apache.org/users/user-guide-query/supported-transformations#json-functions

You meant one can still use the json functiosn after a json array is flattened?

yes

Cool, will give a try. That said, what is the rationale behind not allowing the use of flatten fields in transformation? If we do, I believe 99% of the use cases for json functions can go away :)

how would the query look like?