Thalweg · API reference ← Main docs

make_get_json_object_udf

Function make_get_json_object_udf 

Source
pub fn make_get_json_object_udf() -> ScalarUDF
Expand description

get_json_object(json_string, path) — extract a scalar value from a JSON string using a JSONPath-style path expression.

Supported path forms:

  • Dotted keys: $.a, $.a.b
  • Bracketed quoted keys: $["a"], $['a'], $["a"]["b"]
  • Dotted/special keys inside brackets: $["a.b"] (literal key a.b)
  • Array index access: $.a[0], $[0], $.a[0].b, $[0][1]
  • Mixed: $.a["b"][0].c

Returns the extracted value as a Utf8 string, or NULL if the input JSON is NULL/unparseable, the path is malformed, the path matches nothing, or the matched value is JSON null. Compatible with the Spark/Hive get_json_object signature.