How to extract json array in presto?

@muriel.schmidt 

To extract a JSON array in Presto, you can use the json_array_elements function. Here's an example query that shows how to use this function to extract values from a JSON array:

1

SELECT json_array_elements('[1, 2, 3]') AS array_element;

In this query, the json_array_elements function is being used to extract individual elements from the JSON array [1, 2, 3]. The result of the query will be a table with a single column array_element, which contains each element from the JSON array as separate rows.

You can also use the json_extract function to extract specific elements from a JSON array. Here's an example query that shows how to extract the first element from a JSON array:

1

SELECT json_extract('[1, 2, 3]', '$[0]') AS first_element;

In this query, the json_extract function is being used to extract the first element ($[0]) from the JSON array [1, 2, 3]. The result of the query will be a table with a single column first_element that contains the value 1.

These are just a couple of examples of how you can extract values from a JSON array in Presto. Depending on your specific use case, you may need to modify the query to fit your needs.