title: ARRAY_CONTAINS muliple values in hive
body: <p>Is there a convenient way to use the ARRAY_CONTAINS function in hive to search for multiple entries in an array column rather than just one? So rather than:</p>
  
  <pre><code>WHERE ARRAY_CONTAINS(array, val1) OR ARRAY_CONTAINS(array, val2)
  </code></pre>
  
  <p>I would like to write:</p>
  
  <pre><code>WHERE ARRAY_CONTAINS(array, val1, val2)
  </code></pre>
  
  <p>The full problem is that I need to read <code>val1</code> and <code>val2</code> dynamically from the command line arguments when I run the script and I generally don't know how many values will be conditioned on. So you can think of <code>vals</code> being a comma separated list (or array) containing values <code>val1</code>, <code>val2</code>, <code>...</code>, and I want to write</p>
  
  <pre><code>WHERE ARRAY_CONTAINS(array, vals)
  </code></pre>
  
  <p>Thanks in advance!</p>