JSONPATHEXISTS

This section contains reference documentation for the JSONPATHEXISTS function.

Checks if specified jsonPath exists in jsonField.

Signature

JSONPATHEXISTS(jsonField, 'jsonPath')

Arguments	Description
jsonField	An Identifier/Expression containing JSON documents.
'jsonPath'	Follows JsonPath Syntax to read values from JSON documents.

'jsonPath'` is a literal. Pinot uses single quotes to distinguish them from identifiers. You can use the JsonPath tester tool to test JSON expressions before you import any data.

Usage Examples

The usage examples are based on extracting fields from the following JSON document:

{
  "data": {
    "name": "Pete",
    "age": 24,
    "subjects": [
      {
        "name": "maths",
        "homework_grades": [80, 85, 90, 95, 100],
        "grade": "A",
        "score": 90
      },
      {
        "name": "english",
        "homework_grades": [60, 65, 70, 85, 90],
        "grade": "B",
        "score": 70
      }
    ]
  }
}

Expression	Value
JSONPATHEXISTS(data, '$.name')	true
JSONPATHEXISTS(data, '$.age')	true
JSONPATHEXISTS(data, '$.shoeSize')	false