title: Hive QL Except clause
body: <p>How do I do an <code>EXCEPT</code> clause (like SQL) in Hive QL</p>
  
  <p>I have 2 tables, and each table is a column of unique ids.</p>
  
  <p>I want to find the list of ids that are only in table 1 but not in table 2 </p>
  
  <p><strong>Table 1</strong></p>
  
  <pre><code>apple
  orange
  pear
  </code></pre>
  
  <p><strong>Table 2</strong></p>
  
  <pre><code>apple
  orange
  </code></pre>
  
  <p>In SQL you can do an EXCEPT clause (<a href="http://en.wikipedia.org/wiki/Set_operations_%28SQL%29" rel="noreferrer">http://en.wikipedia.org/wiki/Set_operations_%28SQL%29</a>) but you can't do that in Hive QL</p>