title: Complete list of special characters for hive LIKE operator
body: <pre><code>select * from table where column like '%a|b%'
  </code></pre>
  
  <p>The above query matches all rows with the column having either 'a' OR 'b' as a substring.
  What if I want to match the substring "a|b"?
  Using the query,</p>
  
  <pre><code>select * from table where column like '%a\|b%'
  </code></pre>
  
  <p>yields the same result.</p>
  
  <p>Can I get the complete reference for the LIKE operator in hive? The UDF manual seems insufficient.</p>