Comment on page
jsonextractkey
This section contains reference documentation for the JSONEXTRACTKEY function.
Extracts all matched JSON field keys based on 'jsonPath' into a STRING_ARRAY.
JSONEXTRACTKEY(jsonField, 'jsonPath')
Arguments | Description |
---|---|
jsonField | An Identifier/Expression contains JSON documents. |
'jsonPath' |
'jsonPath'
` is a literal. Pinot uses single quotes to distinguish them from identifiers.The examples in this section are based on the Batch JSON Quick Start. In particular we'll be querying the row
WHERE id = 7044874109
.select id, repo, JSONEXTRACTKEY(repo, '$.*') AS keys
from githubEvents
WHERE id = 7044874109
id | repo | keys |
---|---|---|
7044874109 | {"id":115911530,"name":"LimeVista/Tapes","url":"https://api.github.com/repos/LimeVista/Tapes"} | $['id'],$['name'],$['url'] |
Last modified 1yr ago