CAST(extract_json(...)[1] AS TEXT)does not workinternal error: entered unreachable code: invalid cast from Utf8 to Utf8- when targeting string output, must use
extract_json_stringas workaround. all other output types will useCAST
output
| Field | Value |
|---|---|
| json_parsed_value | "{"string":"abc","number":123,"number_float": 123.456,"boolean":true,"null":null,"string_null":"null"}" |
| json_parsed_json_string | ""abc"" |