title: Hive query: select a column based on the condition another columns values match some specific values, then create the match result as a new column
body: <p>I have to some query and creat columns operations in HiveQL.<br></p>
  
  <p>For example,</p>
  
  <pre><code>app      col1
  
  app1     anybody love me?
  app2     I hate u
  app3     this hat is good
  app4     I don't like this one
  app5     oh my god
  app6     damn you.
  app7     such nice girl
  app8     xxxxx
  app9     pretty prefect
  app10    don't love me.
  app11    xxx anybody?
  </code></pre>
  
  <p>I want to match a keyword list like <code>['anybody', 'love', 'you', 'xxx', 'don't']</code> and select the matched keyword result as a new column, named <code>keyword</code> as follows:</p>
  
  <pre><code>app      keyword
  
  app1     anybody, love
  app4     I don't like this one
  app6     damn you.
  app8     xxx
  app10    don't, love
  app11    xxx
  </code></pre>
  
  <p>It seems that I have to use nested query.<br>
  The logic is kind of like selecting the matched result rows and setting a matched results which should be saved in a list or something like this as a new column.<br> </p>
  
  <p>But I am not familiar enough with the HiveQL.<br>
  Could anyone help me?<br>
  Thanks in advances.<br></p>