This section contains reference documentation for the JSONPATHSTRING function.
Extracts the String value from jsonField
based on 'jsonPath'
, use optional defaultValue
for null or parsing error. This function can only be used in an ingestion transformation function.
JSONPATHSTRING(jsonField, 'jsonPath', [defaultValue])
Arguments | Description |
---|---|
'jsonPath'
` is a literal. Pinot uses single quotes to distinguish them from identifiers.
The usage examples are based on extracting fields from the following JSON document:
This function can be used in the table config to extract the age
property into the age
column, as described below:
Expression | Value |
---|---|
jsonField
An Identifier/Expression contains JSON documents.
'jsonPath'
Follows JsonPath Syntax to read values from JSON documents.
JSONPATHSTRING(data, '$.age')
"24"