JSONPATHARRAY
This section contains reference documentation for the JSONPATHARRAY function.
Extracts an array from jsonField
based on 'jsonPath'
, the result type is inferred based on JSON value. This function can only be used in an ingestion transformation function.
Signature
JSONPATHARRAY(jsonField, 'jsonPath')
Arguments | Description |
---|---|
| An Identifier/Expression contains JSON documents. |
| Follows JsonPath Syntax to read values from JSON documents. |
'jsonPath'
` is a literal. Pinot uses single quotes to distinguish them from identifiers.
Usage Examples
The usage examples are based on extracting fields from the following JSON document:
Expression | Value |
---|---|
|
|
|
|
|
|
This function can be used in the table config to extract the name
, score
, and second value of homework_grades
into their respective columns , as described below:
Last updated