Checking array in Athena : <p>I have a table in Athena where one of the columns is of type <code>array&lt;string&gt;</code>. However, when I run</p>

<pre><code>select * from mytable
where array_contains(myarr,'foobar')
limit 10
</code></pre>

<p>it seems Athena doesn't have the <code>array_contains</code> function:</p>

<pre><code>SYNTAX_ERROR: line 2:7: Function array_contains not registered
</code></pre>

<p>Is there an alternative way to check if the array contains a particular string? </p>
