title: Checking array in Athena
body: <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>