title: Comparing Text in Hive
body: <p>I have one table with text column and another table with keywords column. Now i want to get all the text containing the keywords in another table. I tried using LIKE operator but it is not working. My query looks like this</p>
  
  <pre><code>select screen_name from t_tweets_geo where text like '% select keywords from h_trends %';
  </code></pre>
  
  <p>But this query is not returning anything. Kindly Help</p>