title: What is the HQL equivalent of NOT IN?
body: <p>I am trying to use a <code>NOT IN</code> keyword in Hive Query Language. It seems to be giving me an error: </p>
  
  <pre><code>SELECT Name
  FROM names_in_countries
  WHERE Country = 'Mexico'
  AND Name NOT IN (
      SELECT Name
      FROM names_in_countries
      WHERE Country &lt;&gt; 'Mexico')
  </code></pre>
  
  <p><a href="https://stackoverflow.com/questions/10407415/sql-where-and-distinct">Here is the original question with answer in SQL.</a></p>