Checking the array in Athena

Question

I have a table in Athena where one of the columns is of type array<string> . However, when I run

 select * from mytable where array_contains(myarr,'foobar') limit 10 

Athena doesn't seem to have an array_contains function:

 SYNTAX_ERROR: line 2:7: Function array_contains not registered 

Is there an alternative way to check if an array contains a specific string?

Answer 1

 select * from mytable where contains(myarr,'foobar') limit 10