title: How to check whether a string pattern is present in a hive table column
body: <p>I am using the Cloudera cluster containing Hive-0.13.1 for my day-to-day activities.</p>
  
  <p>I have few string patterns with me and I need to find whether any of these patterns are present in one of the columns in Hive table.</p>
  
  <p>Example: The string patterns I have is short names of cricketers such as "Dravid", "Sachin", "Ganguly". I have a column in the hive which contains the full names of all the cricketers.</p>
  
  <pre><code>select full_name from players limit 3;
  
  Rahul Dravid
  Sachin Ramesh Tendulkar
  Sourav Ganguly
  </code></pre>
  
  <p>I need to compare my string patterns with the values returned by my query and create another column with "Y" if it matches or with "N" if it doesn't match.</p>
  
  <p>How to write Hive query to accomplish this apart from Regex?</p>