Consulta 1
presto:default> select array_intersect(array[1,2,3],array[2,4]) as intersection;
Resultado
intersection
--------------
[2]
Consulta 2
presto:default> select element_at(array[1,2,3],2) as element_position;
Resultado
element_position
------------------
2