title: Hive query with multiple LIKE operators
body: <p>What would be the right way to write a Hive query with multiple LIKE operators like this:</p>
  
  <pre><code>SELECT * 
  FROM some_table
  WHERE
  some_col LIKE '%abc%'
  OR
  some_col LIKE '%xyz%'
  OR
  some_col LIKE '%pqr%'
  OR
  ... (some more LIKE statements)
  </code></pre>
  
  <p>I tried doing the above as well as</p>
  
  <pre><code>WHERE some_col LIKE '%abc|pqr|xyz%' 
  </code></pre>
  
  <p>but they didn't return any results. It works fine if I write separate queries, i.e.</p>
  
  <pre><code>WHERE some_col LIKE '%abc%' -&gt; returns results
  </code></pre>
  
  <p>and</p>
  
  <pre><code>WHERE some_col LIKE '%pqr%' -&gt; also returns results
  </code></pre>