I have a JSON Field in my PostgreSQL database with this format
I want to take all the fields in this flat JSON structure and turn each of them into fields in a typed stream. How would I go about doing that? I tried using the ‘makeJSON’ function on the JSON string column but I’m unable to run JSONNode function on it.
Running the above query results in a ‘CRASH, cannot map’ exception.
Best answer by SidView original
Here is an example with adhoc query
Here is DDL and DML used