title: HIVE SQL Subquery in WHERE Clause
body: <p>I have two tables with similar fields but the query is failing when I am doing a <code>SELECT</code> subquery in a <code>WHERE</code> clause.  </p>
  
  <pre><code>SELECT foo 
  FROM   bar
  WHERE  fizz IN (SELECT fizz FROM fuzz)
  </code></pre>
  
  <p>I deleted the <code>error.log</code> from AWS but the error was something to the extent that HIVE did not recognize the <code>SELECT</code>.</p>
  
  <p>How do I need to restructure this query? </p>
  
  <p>Thanks.</p>