pyflink.table.expression.Expression.json_exists

Expression.json_exists(path: str, on_error: JsonExistsOnError | None = None) → Expression[bool]

Determines whether a JSON string satisfies a given search criterion.

This follows the ISO/IEC TR 19075-6 specification for JSON support in SQL.

Examples:

>>> lit('{"a": true}').json_exists('$.a') # True
>>> lit('{"a": true}').json_exists('$.b') # False
>>> lit('{"a": [{ "b": 1 }]}').json_exists('$.a[0].b') # True

>>> lit('{"a": true}').json_exists('strict $.b', JsonExistsOnError.TRUE) # True
>>> lit('{"a": true}').json_exists('strict $.b', JsonExistsOnError.FALSE) # False

Added in version 1.12.0.