How to extract nested json objects in presto?

@cali_green 

In Presto, you can extract nested JSON objects using the json_extract function.

Here's an example query to extract a nested JSON object:

1
2
3
4
5

SELECT
    json_extract(json_column, '$.nested_object.field1') as field1,
    json_extract(json_column, '$.nested_object.field2') as field2
FROM
    your_table

In this query, json_column is the column containing the JSON data, and nested_object is the key of the nested JSON object you want to extract. You can then access the fields within the nested object using the dot notation $.nested_object.field1.

You can chain multiple json_extract functions to extract multiple fields from the nested object.