title: Multiple data inserts in same dataframe
body: <p>We have customer data in a Hive table and sales data in another Hive table, which has data in TB's. We are trying to pull the sales data for multiple customers and save it to a file.</p>
  
  <p>What we tried so far:</p>
  
  <p>We tired with left outer join between customer and sales tables, but because of the huge sales data it is not working.</p>
  
  <pre><code>val data = customer.join(sales,"customer.id" = "sales.customerID",leftouter)
  </code></pre>
  
  <p>So the alternative is to pull the data form sales table based on specific customer region list and see if this region data has the customer data, if data exist save it in other dataframe and load the data to the same dataframe for all the regions.</p>
  
  <p>My question here is, whether the multiple insert of data for the dataframe is supported in spark.</p>