Sum on Count in hql - error Not yet supported place for UDAF 'count'
<p>I'm new here so please be gentle, my first question after using this website for a long time regards the below:</p>

<p>I'm trying to create a sum of count of events in the past 30 days:</p>

<pre><code>select  key, sum((COALESCE(count(*),0)))
from table
Where date&gt;= '2016-08-13'
And date&lt;= '2016-09-11'
group by key;
</code></pre>

<p>but the sum doesn't seem to work. i'm looking at the last 30 days, and i would like to count any row that exists for each key, and then sum the counts (i need to count on a daily basis and then sum all day's count).</p>

<p>If you can offer any other way to deal with this issue i'm open for suggestions!</p>

<p>Many thanks,
Shira</p>