Apache-presto-element-at
提供:Dev Guides
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