title: How to filter out whole set of batch records in hive
body: <p>I have a table say table A and it has below two columns,</p>
  <pre><code>Id                  Description
  ------------------------------------------------------
  12534554   Item created
  12534554   Item assigned to team
  12534554   Item fixed
  12534554   Item removed from batch
  16733686   Item created
  16733686   Item assigned to team
  18667456   Item assigned to team
  </code></pre>
  <p>Whenever I find the keyword '<strong>Item removed from batch</strong>' in description field, I want to filter out the whole batch and the result should be as below,</p>
  <pre><code>Id                  Description
  -----------------------------------------
  16733686   Item created
  16733686   Item assigned to team
  18667456   Item assigned to team
  </code></pre>