Apache Presto - element_at(array,index)

查询 1

presto:default> select array_intersect(array[1,2,3],array[2,4]) as intersection;

 intersection 
-------------- 
     [2] 

查询 2

presto:default> select element_at(array[1,2,3],2) as element_position; 

element_position 
------------------ 
       2

apache_presto_sql_functions.html