title: Is there sql WITH clause equivalent in hive?
body: <p>Failed to find the answer in the specs.</p>
  
  <p>So, I wonder: Can I do something like that in hive?</p>
  
  <pre><code>insert into table my_table
  with a as
  (
      select *
          from ...
          where ...  
  ),
  
  b as
  (
      select *
          from ...
          where ...  
  )
  select 
      a.a, 
      a.b, 
      a.c, 
      b.a, 
      b.b, 
      b.c 
  from a join b on (a.a=b.a);
  </code></pre>