pyflink.table.expression.Expression.json_exists#
- Expression.json_exists(path: str, on_error: Optional[pyflink.table.expression.JsonExistsOnError] = None) pyflink.table.expression.Expression[bool] [source]#
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
New in version 1.12.0.