JSONPATH(jsonField, 'jsonPath')
jsonField
'jsonPath'
'jsonPath'
` is a literal. Pinot uses single quotes to distinguish them from identifiers.
You can use the Jayway JsonPath Evaluator Tool to test JSON expressions before you import any data.JSONPATH(data, '$.name')
"Pete"
JSONPATH(data, '$.age')
24
name
property into the name
column and age
property into the age
column, as described below: