title: How to use NOT IN in Hive
body: <p>Suppose I have 2 tables as shown below. Now, if I want to achieve result which sql will give using, <code>insert into B where id not in(select id from A)</code> 
  which will insert <code>3 George</code> in Table B.</p>
  
  <p>How to implement this in hive?</p>
  
  <p>Table A</p>
  
  <pre><code>id  name      
  1   Rahul     
  2   Keshav    
  3   George
  </code></pre>
  
  <p>Table B</p>
  
  <pre><code>id  name      
  1   Rahul     
  2   Keshav    
  4   Yogesh   
  </code></pre>