grand total column in Impala using window function
<p>I'm looking for a way to do a "grand total" column across ALL groups in Impala.</p>

<p>It's easy to use window functions to obtain total of partitioned groups like this:</p>

<p>sum(x) over (partition by A)</p>

<p>however it does not appear that there is an expression to partition by 'all'. Is this a shortcoming in Impala? It looks like in postgress you can leave the over statement blank.</p>