title: Multi insert with join in Hive
body: <p>According to Apache Hive Wiki (<a href="https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML" rel="nofollow noreferrer">https://cwiki.apache.org/confluence/display/Hive/LanguageManual+DML</a>),
  multi inserts "minimize the number of data scans required. Hive can insert data into multiple tables by scanning the input data just once (and applying different query operators) to the input data".</p>
  
  <p>But, is it possible to apply joins to these multiple inserts?</p>
  
  <p>I'm asking because I cannot apply the join in the common FROM statement, because I need to subset the data of the second table taking into account different parameters for each "first" table.</p>
  
  <p>Thanks in advance!</p>