HiveQL if operators regroup in one line
Request:
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
Result:
_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
Is there any result for just one line?
_c0 _c1
0 277917 1368
+3
source to share