title: How to write "where" clause in hive to filter out values in another table
body: <p>I have a table "mytable" contains several columns including one called "ip." There is another table called "bots" with only one column "bot", which is a list of several ip address values. I want to filter out all rows in mytable with "ip" value in table bots.</p>
  
  <p>I wrote </p>
  
  <pre><code>select * from mytable
  where ip not in (select bot from bots);
  </code></pre>
  
  <p>Apparently this is not the way to do it. I am wondering what is the correct syntax.</p>
  
  <p>I googled around but the keywords here "where" and "in" are too common in the English language and hence hard to find any useful results.</p>