jsonField
based on 'jsonPath'
, use optional defaultValue
for null or parsing error. This function can only be used in an ingestion transformation function.JSONPATHLONG(jsonField, 'jsonPath', [defaultValue])
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.JSONPATHLONG(data, '$.age')
24
age
property into the age
column, as described below: