Details
-
New Feature
-
Status: Open
-
Major
-
Resolution: Unresolved
-
4.0.0
-
None
-
None
Description
Support JSON path expression by adding COLON sign operator [1] and JSON path expression [2]
[1] https://docs.databricks.com/en/sql/language-manual/functions/colonsign.html
[2] https://docs.databricks.com/en/sql/language-manual/sql-ref-json-path-expression.html
Syntax:
jsonExpr : jsonPath
jsonExpr can be either a VariantType or a valid JSON String.
- when jsonExpr is a valid JSON String, use an inner function semi_structured_extract_json_multi that is to be added with a new RegexParser such that the jsonPath is more flexible than get_json_object).
- when jsonExpr is a VariantType, apply the built-in function variant_get