title: Hive: Unable to get summation of different categories
body: <p>From Hive, i am trying to get the result from simple table which looks below</p>
  
  <pre><code>custername Prjtid Hours  Billable_Status
  
  ABC         AB123  10     Billable
  
  ABC         AB123  20     Non-Billable
  
  ABC         AC123  10     Billable
  
  ABC         AB123  30     Billable
  
  PQR         PQ123  20     Billable
  
  PQR         PQ123  30     Billable
  
  PQR         PQ123  20     Non-Billable
  </code></pre>
  
  <p>Now i want to display like,</p>
  
  <p><code>Custername, Prjtid, (Total number of billable), (total number of non-billable).</code></p>
  
  <p>Example: </p>
  
  <p><code>ABC, AB123, 40, 20</code></p>
  
  <p><code>PQR, PQ123, 50, 20</code></p>
  
  <p>I am able to get for Billable or non-billable but not together. </p>
  
  <p>Could anyone please advice how to go ahead with this scenario?</p>
  
  <p>Regards,</p>
  
  <p>Raj</p>