title: Spark SQL broadcast hint intermediate tables
body: <p>I have a problem using Broadcast hints (maybe is some lack of SQL knowledge).</p>
  
  <p>I have a query like</p>
  
  <pre><code>SELECT * /* broadcast(a) */
  FROM a 
  INNER JOIN b
  ON ....
  INNER JOIN c
  on ....
  </code></pre>
  
  <p>I would like to do</p>
  
  <pre><code>SELECT * /* broadcast(a) */
  FROM a 
  INNER JOIN b 
  ON ....
  INNER JOIN c /* broadcast(AjoinedwithB) */
  on ....
  </code></pre>
  
  <p>I mean, I want to force broadcast join (I would prefer to avoid changing spark parameters to force it everywhere), but I don't know how to refer to the table named <code>AjoinedwithB</code></p>
  
  <p>Of course I can split the SQL, work with DF API and such... but I would like to do it in a single SQL Query.</p>