title: Does PIG have NOT IN clause
body: <p>I'm trying like</p>
  
  <pre><code>select * from A where A.ID NOT IN (select id from B) (in sql)
  
  filtersource= FILTER source BY ID NOT(destination.ID)
  </code></pre>
  
  <p>How to do NOT IN clause or some other technique to keen out the extra records present in one table using pig</p>