title: Array contains string from column in Athena
body: <p>I'm trying to check if at least one element of <code>my_array</code> array  contains a string from <code>my_column</code> column in athena. I want the end result to be a boolean.</p>
  <p>I've tried :</p>
  <pre><code>contains(my_array, my_column)
  </code></pre>
  <p>It seems to be partially working and I actually can't understand why because sometimes I get <code>false</code> even though the element of the array and the string are matching, but I never get true if there's no match.</p>
  <p>So I've also tried  (as seen here : <a href="https://stackoverflow.com/questions/50766928/presto-array-contains-an-element-that-likes-some-pattern">Presto array contains an element that likes some pattern</a> )</p>
  <pre><code>cardinality(filter(my_array, x-&gt;x like my_column))&gt;0
  </code></pre>
  <p>But same issue, ending with the exact same result as above.</p>
  <p>I thought I had an issue with some values from <code>my_column</code>, but after checking all my problematic values it appears the strings from <code>my_column</code> are clean.</p>
  <p>For instance I am able to find a match for the first value of <code>my_array</code>, but no match for the second, although both values are in <code>my_column</code>.</p>
  <p>Could someone please help ?
  Thank you so much !!</p>