title: hiveQL if statements regroup on one row
body: <p>Query :   </p>
  
  <pre><code>select IF(type='view', count(*), 0), IF(type='click', count(*), 0)
  from ad_events
  where year=2013 and month=01 and day=18 and (hour=01 or hour=02)
  group by type
  </code></pre>
  
  <p>Result :</p>
  
  <pre><code>      _c0       _c1
  0      0         0
  1      0         0
  2      0       1368
  3      0         0
  4      0         0
  5      0         0
  6      0         0
  7      0         0
  8   277917       0
  9      0         0
  </code></pre>
  
  <p>Is there anyway to have the result only on one row like that ? :</p>
  
  <pre><code>      _c0       _c1
  0    277917     1368
  </code></pre>