Last updated
Was this helpful?
Last updated
Was this helpful?
Extracts all matched JSON field keys based on 'jsonPath' into a STRING_ARRAY.
JSONEXTRACTKEY(jsonField, 'jsonPath')
'jsonPath'
` is a literal. Pinot uses single quotes to distinguish them from identifiers.
The examples in this section are based on the . In particular we'll be querying the row WHERE id = 7044874109
.
This section contains reference documentation for the JSONEXTRACTKEY function.
jsonField
An Identifier/Expression contains JSON documents.
'jsonPath'
Follows to read values from JSON documents.
7044874109
{"id":115911530,"name":"LimeVista/Tapes","url":"https://api.github.com/repos/LimeVista/Tapes"}
$['id'],$['name'],$['url']