Apache Presto - element_at (array, index)
Domanda 1
presto:default> select array_intersect(array[1,2,3],array[2,4]) as intersection;
Risultato
intersection
--------------
[2]
Domanda 2
presto:default> select element_at(array[1,2,3],2) as element_position;
Risultato
element_position
------------------
2