title: reference count(*) as total in hive and use total later in same select statement
body: <p>I am trying to reference count(*) , save it as total and reference it later but it is not working </p>
  
  <p>for eg :</p>
  
  <pre><code>  select ((count(*) as total)-count(a)),
    (total - count(b)),
     (total - count(c))
      from table;
  </code></pre>
  
  <p>What's wrong?</p>