title: check if all elements in hive array contain a string pattern
body: <p>I have two columns in a hive table that look something like this:</p>
  
  <pre><code>code    codeset
  AB      AB123,MU124
  LM      LM123,LM234
  </code></pre>
  
  <p>I need to verify that all elements in codeset column contain the value in code column so in the above example the first row would be false and the second row would be true.</p>
  
  <p>Is there a simple way to do this that I am missing? I already read about array_contains but that returns true if just one element matches, I need all elements to contain what's in the code column.</p>
  
  <p>Thanks in advance.</p>