Hi All do we have some example to extract attributes from json objects in transformFunction

you would typically use jsonFormat or jsonPath functions. https://docs.pinot.apache.org/users/user-guide-query/supported-transformations#json-functions Here’s a video showing a demo of this:

Hi @User Thx for your replay, If json path is null, will pinot throw exception or just give null instead thx

if your whole jsonField (e.g. person) is null, you’ll get an exception. But if just the jsonPath (person.address.state) is null, you will get null, or default value that you set

JSONPATHSTRING(person, '$.address.state', 'CA')

Got it, thx @User