title: Hive : Multiple In-elements with single subquery
body: <p>I was trying to run a query like this on hive (version 1.2.1) :</p>
  
  <pre><code>DELETE  FROM employee as e WHERE  (e.id, e.name) IN ( SELECT emp.id, emp.name FROM employee_final  emp) AND e.sno = 120 ;
  </code></pre>
  
  <p>But since hive doesn't support this construct so I tried this :</p>
  
  <pre><code>DELETE FROM employee WHERE 
  id  IN (  SELECT emp.id  FROM employee_final AS  emp ) 
  AND 
  name IN ( SELECT emp.name  FROM employee_final AS  emp      )  
  AND e.sno = 120 ;
  </code></pre>
  
  <p>But it seems there is a limitation in hive and it supports just 1 subquery and I am getting an exception like this</p>
  
  <blockquote>
    <p>Error Message :  Grammatically incorrect SQL Query :]; nested
    exception is org.apache.hive.service.cli.HiveSQLException: Error while
    compiling statement: FAILED: SemanticException [Error 10249]: Line
    1:185 Unsupported SubQuery Expression 'name': Only 1 SubQuery
    expression is supported.</p>
  </blockquote>
  
  <p>What is the most efficient way to handle this problem.</p>