How to cross join unnest a json array in presto?

@lindsey.homenick 

To cross join and unnest a JSON array in Presto, you can use the following query:

1
2
3

SELECT *
FROM table 
CROSS JOIN UNNEST(json_parse(column_name)) AS t(column_name)

In this query:

• Replace table with the name of your table.
• Replace column_name with the name of the column containing the JSON array.
• json_parse() function is used to parse the JSON array into individual rows.
• UNNEST() function is used to unnest the JSON array and return each element as a separate row.
• t is an alias for the unnested JSON array column.

This query will cross join the original table with the unnested JSON array, resulting in a new row for each element in the JSON array.