title: Sum on Count in hql - error Not yet supported place for UDAF 'count'
body: <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>