title: NOT IN clause in PIG
body: <p>I'm trying like</p>
  
  <pre><code>select * from A where A.ID NOT IN (select id from B) (in sql)
  
  sourcenew = LOAD 'hdfs://HADOOPMASTER:54310/DVTTest/Source.txt' USING PigStorage(',') as (ID:int,Name:chararray,FirstName:chararray ,LastName:chararray,Vertical_Name:chararray ,Vertical_ID:chararray,Gender:chararray,DOB:chararray,Degree_Percentage:chararray ,Salary:chararray,StateName:chararray);
  destnew = LOAD 'hdfs://HADOOPMASTER:54310/DVTTest/Destination.txt' USING PigStorage(',') as (ID:int,Name:chararray,FirstName:chararray ,LastName:chararray,Vertical_Name:chararray ,Vertical_ID:chararray,Gender:chararray,DOB:chararray,Degree_Percentage:chararray ,Salary:chararray,StateName:chararray);
  c= FOREACH destnew GENERATE ID;
  D=FILTER sourcenew BY NOT ID (c.ID);
   org.apache.pig.tools.pigscript.parser.ParseException: Encountered " &lt;PATH&gt; "D=FILTER "" at line 1, column 1.
  Was expecting one of:
  &lt;EOF&gt; 
  "cat" ...
  "clear" ...&lt;EOF&gt;
  </code></pre>
  
  <p>any help on this to resolve error, getting this on the execution of last line.</p>