title: LEFT ONLY Join in Pig (A - B)
body: <p>I have two data sets</p>
  
  <p><strong>File1</strong></p>
  
  <pre><code>11,A,2013
  12,B,2014
  13,C,2015
  </code></pre>
  
  <p><strong>File2</strong></p>
  
  <pre><code>11,A,2016,Y
  15,D,2017,Y
  13,C,2016,N
  10,K,2017,N
  </code></pre>
  
  <p>I want to do a Left Only join based on first column on these data sets.
  Here is my Pig script.</p>
  
  <pre><code>A_C01 = LOAD '/user/uszanr8/pigtest/file3' using PigStorage(',') ; 
  B_C08 = LOAD '/user/uszanr8/pigtest/file1'  using PigStorage(','); 
  C_C01_FILT = FILTER A_C01 BY $3 == 'Y';
  E_JOINED_BY_CLM_NBR = JOIN C_C01_FILT BY $0 , B_C08 BY  $0 ;
  DUMP E_JOINED_BY_CLM_NBR;
  </code></pre>
  
  <p>My actual data has far more records and columns.</p>
  
  <p>How can I get the records from left data set that has no matches with right data set that is filtered in Pig without using cogroup.</p>