Hi all, when pinot to consuming kafka , how to parse nest json such like { “data”: { “name”: “cc”, “age”: 3 } } I just need “name” and age in table

You have to define

name

and

age

in schemaConfig. After that, You need to use the json inbuilt functions in the transform config to extract those fields.

And then i need to use json functions during query time

You won’t have to. Once you have defined transformConfigs during ingestion, you would be able to select the fields directly.

select name from your_table

Ok ,thx ,if this method will not have good performance compare to flatten json

If you are ingesting it as a string you can use those functions during query time. Else you can extract them during ingestion itself.