title: How does one do a SQL select over multiple partitions?
body: <p>Is there a more efficient way than:</p>
  
  <pre><code>select * from transactions partition( partition1 ) 
  union all 
  select * from transactions partition( partition2 ) 
  union all 
  select * from transactions partition( partition3 ); 
  </code></pre>