title: Hive multiple subqueries
body: <p>I'm using Hive 0.9.0 and I'm trying to execute query i.e.</p>
  
  <pre><code>`SELECT a.id, b.user FROM (SELECT...FROM a_table) a, (SELECT...FROM b_table) b WHERE a.date   = b.date;`
  </code></pre>
  
  <p>but it returns error "loop (...)+ does not match input....".
  Does Hive support multiple subqueries in FROM just like Oracle DB?</p>